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 |
All times are GMT +1. The time now is 01:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com