Hi all,
I'm not used to VBA and am having a bit difficulty putting together code for a combobox selection that hides and unhides sheets based on its selection. Eg. A combobox that has a dropdown list of 2, 3, 4, & 5. Sheets 2-5 are hidden by default (before selecting value in the combobox). Upon selecting "2", it should unhide sheet 2. If I select "3" it should unhide sheet 3 but hide sheets 2, 4, & 5 and so on.. sheet 1 is to stay unhidden at all times.
I hope I have explained it clearly and would greatly appreciate your assistance![]()
Bookmarks