How to make a Macro perform "reset" in LIST BOX

[carlywhat223]

Hi there. I am trying to create a tool, in which needs a "reset" once the user has completed the task...... I can get the Macro to work to clear cells (using a button) however can not figure out how to make the list boxes shift to a set "choice" within the listbox during the reset button command via macro. Any help is appreciated. I have lots more to do in this workbook however don't want to proceed until i can understand the ListBox "reset" options via Macros....

[Norie]

What exactly do you mean by 'reset'?

Also, where is the listbox located and how did you create it?

[walruseggman]

Please Login or Register  to view this content.

That initializes the list and then selects "Select Choice".

If you wanted to "reset" the listbox, you could just use that last line of code, if that's what you mean by reset.