Validation Drop Down

[Todd Huttenstine]

Hey guys

I have a cell will a validation drop down box. When you
click the cell, a down arrow pops up beside the cell to
the right. If you click the down arrow, the drop down
list displays.

Lets say the validation drop down is in cell A1.
How do you programmatically get this dropdown box list to
display?


Thanks you
Todd Huttenstine

 

[Tom Ogilvy]

Sub Tester11()
Range("A1").Select
SendKeys "%{down}"
End Sub

 

[Todd Huttenstine]

Thanks Tom

-----Original Message-----
Sub Tester11()
Range("A1").Select
SendKeys "%{down}"
End Sub

--
Regards,
Tom Ogilvy





.