Validation Drop Down
 

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

Validation Drop Down
 

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

--
Regards,
Tom Ogilvy


"Todd Huttenstine" wrote in message
...
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

Validation Drop Down
 

Thanks Tom


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

--
Regards,
Tom Ogilvy


"Todd Huttenstine"
wrote in message
...
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


.