• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 352
  • Last Modified:

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
0
tora111
Asked:
tora111
1 Solution
 
Martin LissOlder than dirtCommented:
If your listboxes are ActiveX controls then

Private Sub ListBox1_Click()
ListBox2.ListIndex = 0
ListBox3.ListIndex = 0
ListBox4.ListIndex = 0
End Sub
0
 
tora111Author Commented:
Hi MartinLiss,

I'm not using ActiveX control. In other words, is it possible to reset the dropdown list value except VBA?
0
 
Elton PascuaCommented:
I can't think of any other solution except VBA. Attached is a sample worksheet on a VBA Solution.
reset-dropdown.xlsm
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now