Excellent! Thank you very much.

Thanks.

Hi, Thanks for your awesome videos. Can someone tell me when i use mouse to change the value in list box (by clicking the up or down arrow) the value doesn't get changed in the code. Excel still uses the old value and populates the same in my excel table. I have to manually select the box then the value gets updated. How can i make the code use updated value in the box all the time?