I am trying to find a way to have a command button open a userform having 2 buttons on it say "2013" and "2014" and when the user click one of them it opens another form having few more buttons on it say "Dashboard", Dashboard1". Dashboard2", dashboard3" and etc.
What I am looking for is like 5 command buttons that will be placed on an excel sheet. The user will press a button and it will open a form with 2 buttons say "2013" and "2014".and when the user click one of them it opens another form having few more buttons on it say "Dashboard", Dashboard1". Dashboard2", dashboard3" and etc. Clicking any of these buttons with links should open a particular folder. The part I really know nothing about is how can I insert a userform inside a userform and so on.
the form should be something like this on a spreadsheet:
Button1 button2 Button3 button4 Button5
I
Button1 (2013)
I
Jan
Feb
Mar
Apr
May ------- Possibly in a listbox
Jun
Jul
Aug
Sep
Oct
Nov
Dec
I
When anyone of the above months is selected a userform having few more buttons say "Dashboard", Dashboard1". Dashboard2", dashboard3" should open and clicking any of these buttons should take us to some pre defined folders.
I am working on a sample right now will attach it for your reference but, if any one of you have any alternate ideas to do this please advice.
Thanks in advance
Sumit