How to automatically show list in a validation list?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a cell that has a validation list (already populated). I have added a
button next to the cell so that when a user selects it, it will automatically
go to the validation list cell and show the list without having to click on
the down arrow. Can anyone help with the code for this? I have the code to
get to the cell which is easy (Range("A6").Select) but can't get the dropdown
list to show automatically.

Thanks,
Roger
 
This works:

Sub ShowDVList()
Range("A6").Select
SendKeys "%{DOWN}"
End Sub

Does that help?
***********
Regards,
Ron

XL2003, WinXP
 
I'm glad that worked for you, Roger......and thanks for the feedback.


***********
Regards,
Ron

XL2003, WinXP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation List (conditional) 2
Conditional Validation In Excel 1
Pick from drop-down list gives empty or erroneous result 6
Data Validation - Dependent List 3
autofilling a cell as the user types 1
How to Update Selections for (Numerous) Validation Lists 1
Validation List 7
Data Validation Drop Down Using VBA? 1

Back
Top