Reset From Control List Box

[IvanJames]

Hello,

I am trying to change some list boxes on my worksheet from Active X to Form due to some weird locking issue that no one seems to be able to solve. However, the code I was using to reset the list bo via command button does not seem to work anymore. here is the code I am using:

Please Login or Register  to view this content.

Does a form control list box not allow this type of reset?

[Norie]

You need to refer to Forms listboxes differently and to reset them you need to set the ListIndex to 0.

For example this code, which goes in a standard module, resets a listbox named 'List Box 1' using a command button named 'Button2', both controls are Forms and are located on 'Sheet2'

Please Login or Register  to view this content.

[IvanJames]

That worked! Thanks so much!