Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all,
This seems like a simple question, but I can't find the answer. I have a user form with a listbox control. I populate this control by setting the List property to a two-dimensional array. The listbox is populated based on the user's input into other controls. The same user form also has a reset button if the user wants to start over. In the click event of the reset button, I want to do something to completely clear the listbox of its contents. I've tried using the clear method, which throws "Unspecified Error". I've tried setting the List property to a blank two-dimensional array, which throws "Permission Denied". I've tried looping through the list and using the RemoveItem method, but that throws "Unspecified Error". I do have event handlers in the listbox on click event, but the call doesn't seem to be recursive (is that the right term?). Any ideas? Thanks, Johnny |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
want to erase the 0 | Excel Discussion (Misc queries) | |||
Erase Key in Legend | Charts and Charting in Excel | |||
Erase Duplicates | Excel Worksheet Functions | |||
SELECT, ERASE, EDIT items in listbox | Excel Programming | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming |