Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
expandable listbox
Andrew,
http://support.microsoft.com/?kbid=213748 XL2000: How to Populate One List Box Based on Another List Box Regards, Jim Cone San Francisco, CA "Andrew Smith" wrote in message om... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Expandable data range for a chart | Charts and Charting in Excel | |||
expandable Text Box | Excel Worksheet Functions | |||
formatting, expandable trees? | Excel Discussion (Misc queries) | |||
how do I make an expandable list in Excel? | Excel Discussion (Misc queries) | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming |