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