yadafarin
asked on
how to clear all items in listbox in VBA?
hi
in VBA, how can i remove all items in listbox object?
I don't know number of items.
thanks
in VBA, how can i remove all items in listbox object?
I don't know number of items.
thanks
ASKER
no, it hasn't rowsource.
I add items in listbox by VBA code (with .Additems).
I add items in listbox by VBA code (with .Additems).
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
did this work
if so, set rowsource to ""
e.g. listbox.rowsource = ""
u may need to refresh/requery it