• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 349
  • 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 LissRetired ProgrammerCommented:
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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