Please see attached .xls
As simply as I can put it, I have a sheet with various sections.
I would like to have a combobox which, when used, selects a section and then displays only that section, hiding the other.
Using the attached for example, by default the sheet only shows the section 'List1' however the combobox has an option of selecting either 'list2' or 'list1'. Which ever is selected the other is hidden.
Hope that makes sense.
Use Custom Views from the View menu.
I've created two based on your sheet, added a Dynamic Named Range to populate the Combobox, a formula to get the selected view & a simple macro to open the selected view
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Thanks RoyUK
I'm unable to download your .xls here, could you please paste the code for the macro here?
I know how to go about the rest
on Sheet2
Dynamic Named Range to link the Combobox to
C1 is the linked cell
C2 contains =Index(Views,C1)
The macro assigned to the Combobox is
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks