Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pick Lists
Here is a way to add it as Data Validation in VBA
With Selection.Validation .Delete .Add Type:=xlValidateList, _ AlertStyle:=xlValidAlertStop, _ Operator:=xlBetween, _ Formula1:="Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec" End With -- HTH RP "Budget Programmer" wrote in message ... Hello, I'd like to make a pick list of months (Jan, Feb, Mar, etc.) for the user to choose from, capture the choice and use the variable. It seems that I can use a form and the ComboBox ActiveX control, but I'm wondering if there is a way I can do this in VBA, without a seperate form. Thanks very much for your help. -- Programmer on Budget |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pick from lists | Excel Discussion (Misc queries) | |||
Pick from lists | Excel Worksheet Functions | |||
How do I use an IF statement to pick between two lists? | Excel Discussion (Misc queries) | |||
Using Pick Lists | Excel Worksheet Functions | |||
Pick Lists | Excel Programming |