How to automatically show list in a validation list?

's Computer Specifications

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

's Computer Specifications

SendKeys "%{DOWN}"

Bill Renaud

's Computer Specifications

This works:

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

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

XL2003, WinXP

"Roger L" wrote:

> 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
>

's Computer Specifications

So...simple and it works perfect! Thanks so much Ron!!! I really appreciate
it.

"Ron Coderre" wrote:

> This works:
>
> Sub ShowDVList()
> Range("A6").Select
> SendKeys "%{DOWN}"
> End Sub
>
> Does that help?
> ***********
> Regards,
> Ron
>
> XL2003, WinXP
>
>
> "Roger L" wrote:
>
> > 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
> >

's Computer Specifications

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

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

XL2003, WinXP

"Roger L" wrote:

> So...simple and it works perfect! Thanks so much Ron!!! I really appreciate
> it.
>
> "Ron Coderre" wrote:
>
> > This works:
> >
> > Sub ShowDVList()
> > Range("A6").Select
> > SendKeys "%{DOWN}"
> > End Sub
> >
> > Does that help?
> > ***********
> > Regards,
> > Ron
> >
> > XL2003, WinXP
> >
> >
> > "Roger L" wrote:
> >
> > > 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
> > >

's Computer Specifications

Thanks Bill!

"(E-Mail Removed)" wrote:

> SendKeys "%{DOWN}"
>
> Bill Renaud
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Data validation list - list doesn't show items from top	Pwinkle	Microsoft Excel Misc	0	23rd Jun 2009 07:56 PM
Use VBA to reset data validation (=list) value to first value in that list (list is a named range)	ker_01	Microsoft Excel Programming	7	27th Oct 2008 03:13 PM
Automatically update data validation list	roniaelm@hotmail.com	Microsoft Excel Programming	5	5th Jul 2008 02:11 PM
Validation List with Value to pop up automatically	CYNTHIA	Microsoft Excel Worksheet Functions	3	23rd Mar 2008 04:17 AM
I want to automatically alphabetize my list for my validation.	=?Utf-8?B?R2xpY2U=?=	Microsoft Excel Programming	2	20th Mar 2006 05:17 PM