| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
listbox - How to reset the values
Great, perfect super, Thanks Tom! (and Nick HK)
"Tom Ogilvy" wrote: Private Sub ListBox1_MouseDown(ByVal Button As Integer, _ ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single) ListBox1.ListIndex = -1 End Sub -- Regards, Tom Ogilvy "NezRhodes" wrote in message ... Nick I added this line of script to the end of my macro: ListBox1.ListIndex = -1 and unfortunately it does not reset the listbox. Can you clarify your answer a little please? "NickHK" wrote: Set its .ListIndex to -1 NickHK "NezRhodes" ... Hello Gurus - I have written a macro on the back of a listbox button that allows the user to select a worksheet to update. However, once a selection is made the list box retains this choice so the user cannot select the same choice again. How do I reset the listbox so none of the options are selected? Thank you in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i reset excel to its default values? | Excel Worksheet Functions | |||
| How can I use this VB script to reset my values on other sheets? | Excel Programming | |||
| reset values in select cells | Excel Discussion (Misc queries) | |||
| Fill values into a listbox matching selected values from a combobox | Excel Programming | |||
| Sorting ListBox results or transposing ListBox values to other cells for sorting | Excel Programming | |||
Threaded Mode
