View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Johnny[_10_] Johnny[_10_] is offline
external usenet poster
 
Posts: 30
Default Completely Erase ListBox

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