Creating a drop down list
Try something like this Workbook_Open event code:
Private Sub Workbook_Open()
With Sheet1.Range("B2")
.Select
Application.SendKeys ("%{DOWN}")
End With
End Sub
Is that something you can work with?
--------------------------
Regards,
Ron (XL2003, Win XP)
Microsoft MVP (Excel)
"bethjoy79" wrote in message
...
I used validation to create a drop down list, but my question is how to
make
that drop down appear when I open the worksheet instead of just clicking
on
the cell?
Thanks,
Beth
|