HvyEquipment
New Member
- Joined
- Apr 19, 2004
- Messages
- 11
OK, everyone, I know that this has come up repeatedly, and I've read most of the posts regarding it, but I still need some help (and Data Validation just isn't the right format for my application). I need to be able to Cascade three consecutive ComboBox's in a row, with the 2nd and 3rd invisible until a selection is made from the one previous to it.
The 2nd and 3rd ComboBox lists are dependent upon the previous ComboBox selection.
To top it all off, I need the 3rd and final selection to 'jump' to Cell A1 in a specific Worksheet associated with the cascading selection.
For Example:
ComboBox1 will always list: Sales, Service, Safety
ComboBox2 will list: Sales1, Sales2, Sales3 (if the 1st = 'Sales')
ComboBox2 will list: Service1, Service2, Service3 (if the 1st = 'Service')
ComboBox2 will list: Safety1, Safety2, Safety3 (if the 1st = 'Safety')
ComboBox3 will list: Sales1-1, Sales1-2 (if the 1st = 'Sales' & the 2nd = 'Sales1')
ComboBox3 will list: Sales2-1, Sales2-2 (if the 1st = 'Sales' & the 2nd = 'Sales2')
etc.
The lists are simplified for explanatory purposes, but will vary and cannot be mathematically calculated.
Once the 3rd selection has been made, it would need to jump to a specific Worksheet, Cell A1 (I've been able to make the 'jump' work, it's the cascading Combobox's that give me fits).
I am not new to programming...just old school and not up on VB (am I giving away my age?).
Seriously, any help would be greatly appreciated and sorry for the long post.
The 2nd and 3rd ComboBox lists are dependent upon the previous ComboBox selection.
To top it all off, I need the 3rd and final selection to 'jump' to Cell A1 in a specific Worksheet associated with the cascading selection.
For Example:
ComboBox1 will always list: Sales, Service, Safety
ComboBox2 will list: Sales1, Sales2, Sales3 (if the 1st = 'Sales')
ComboBox2 will list: Service1, Service2, Service3 (if the 1st = 'Service')
ComboBox2 will list: Safety1, Safety2, Safety3 (if the 1st = 'Safety')
ComboBox3 will list: Sales1-1, Sales1-2 (if the 1st = 'Sales' & the 2nd = 'Sales1')
ComboBox3 will list: Sales2-1, Sales2-2 (if the 1st = 'Sales' & the 2nd = 'Sales2')
etc.
The lists are simplified for explanatory purposes, but will vary and cannot be mathematically calculated.
Once the 3rd selection has been made, it would need to jump to a specific Worksheet, Cell A1 (I've been able to make the 'jump' work, it's the cascading Combobox's that give me fits).
I am not new to programming...just old school and not up on VB (am I giving away my age?).
Seriously, any help would be greatly appreciated and sorry for the long post.