Hi Excellovers and VBA cracks,
first of all I want to thank a lot of guys in this forum. I gathered a lot of informationen and found out that in most cases,
I am not the only one searching a solution for the same problem.
This time I really need your help. So thank you in advance for all the answers.
The Problem I want to solve is.
I have 6 comboboxes in a UserForm with possible selections from 1 to 20.
Selection is done to unhide Sheets with predefined Sheetnames.
Let's say the comboboxes are for Productcategories:
We have
Cars
Boats
Bicycles
Motorbikes
Trailers
And so on
If we Select Cars and the value in the combobox 10, then the following Sheets should be unhided:
Cars1,Cars2,Cars3-----,Cars10
If we select Boats and the value 2 -> Boats1 and Boats2 should be visible.
(Cars should still be display, becaue the value 10 was entered in the combobox of cars.)
This will be used as kind of a configtemplate before working in the actual sheets.
If you need further information please let me know. Sorry for the long text.
Susi
Bookmarks