Cascading Userform Listbox Menu System.

HighAndWilder

Active Member
Joined
Nov 4, 2006
Messages
304
Office Version
  1. 365
Platform
  1. Windows
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
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Forum statistics

Threads
1,176,137
Messages
5,901,567
Members
434,906
Latest member
Prabhu_Churi

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top