Cascading Userform Listbox Menu System.

[HighAndWilder]

Hi. I'm building a Userform to be used as a template for others in the future.

I have horizontal menu options across the top represented by labels. Hovering over a label displays a level one list box with appropriate options.

I would like it that hovering over any the listbox options displays a further listbox offset to the side and slightly below.

I don't see a need to go down to more than five levels so I'll only have five list boxes and change the content, position, size of these etc as appropriate although if I
built this correctly I could go down to any levels I wanted to. I could create listboxes at run time if necessary.

I'd like the size of the listboxes to be determined by the content and the position determined by the parent list box item selected.

I don't want to hard code any of the menus and menu options so they will need to be contained in a hidden worksheet and then maybe loaded into
an array when the Userforms is initialised.

I'm fine with the VBA, including the hovering, but I would like some ideas as to how I can structure the data needed by the menu system.

Does anybody know of any examples of such a cascading menu system online?

Thanks

 

[dmt32]

Hi,

have a look here: Adding a Menu system to UserForms

member has provided link to download sample workbook & may save you a lot of work

Dave