expandable listbox
Hi,
I would like to create an expandable listbox in an excel vba userform.
For example, say I have a listbox with a bunch of categories of
animals: birds, reptiles, mammals, insects, etc. I would like the
listbox to come up initially only desplaying these large categories.
Then I would like the user to be able to click on something to have
birds expand into pigeons, seagulls, penguins, crows, etc, which the
user can then select. Is this possible?
Thanks,
Andrew
|