Hi everyone!
I hope you are well. I have a list box in my userform linked to a name range list. Usually the user scroll through the ListBox but does not actually select the item so, when the form transfer the data onto the sheet that cell remains empty.
Is there a way to tell the ListBox to select the item displayed without clicking it? I have specified the "SelectSingle" behavior but it is still the same.
Many thanks for your support!
Bookmarks