tora111
asked on
Reset Dropdown List
In my spreadsheet, I hv 4 dropdown list;
Example:
Dropdown 1
Click to Select <Name>
ABC
DFG
TER
Dropdown 2
Click to Select <Score>
10
20
30
Dropdown 3
Click to Select <Age>
20-30
30-40
Dropdown 4
Click to Select <Job>
Customer Service
Banking
Can I have all 3 reset, Dropdown 2~4 reset to Click to Select, as Dropdown 1 changed;
Thank you
Example:
Dropdown 1
Click to Select <Name>
ABC
DFG
TER
Dropdown 2
Click to Select <Score>
10
20
30
Dropdown 3
Click to Select <Age>
20-30
30-40
Dropdown 4
Click to Select <Job>
Customer Service
Banking
Can I have all 3 reset, Dropdown 2~4 reset to Click to Select, as Dropdown 1 changed;
Thank you
ASKER
Hi MartinLiss,
I'm not using ActiveX control. In other words, is it possible to reset the dropdown list value except VBA?
I'm not using ActiveX control. In other words, is it possible to reset the dropdown list value except VBA?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Private Sub ListBox1_Click()
ListBox2.ListIndex = 0
ListBox3.ListIndex = 0
ListBox4.ListIndex = 0
End Sub