Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
dynamic value insertion - possible with menu??
Hello,
I am trying to take a spreadsheet and build a user interface piece based on the values in the worksheet. I need something dynamic so I can take the same sheet with different values and still have a working interface. I essentially want to build a menu system of buttons or whatever works in excel based on my values. For example, I want to loop through a column of categories on a sheet included in the workbook, and have them listed on another worksheet in the same workbook. When the user selects one of those categories, I want to check the subcategories on the other worksheet and then list those...and so, until the user gets to the root category that they are looking for. I assumed I could do this using a control array of buttons, but apparantly this does not work in VBA. Does anybody have any suggestions on the best way to do this? I need something generic since my categories will change depending on who I send the spreadsheet to. Thanks for any advice and thanks to all those that helped me last time! B. Rubble |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Row Insertion | Excel Discussion (Misc queries) | |||
Drop down menu with Dynamic data | Excel Discussion (Misc queries) | |||
Rows Insertion | Excel Worksheet Functions | |||
Rows Insertion | Excel Discussion (Misc queries) | |||
Prevent row insertion | Excel Discussion (Misc queries) |