| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
user form - drop down set values
Hi,
I have dropdown (coprocess.List) which pulls data from below code... coprocess.List = ThisWorkbook.Sheets(1).Range("CL7:CL16").Value I wish it should give me a error or message when user puts something which is not in the drop down. Thanks! Boss |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
user form - drop down set values
Would changing the Style property of the ComboBox (what I assume you are
using when you say "drop down" on a UserForm) to 2-fmStyleDropDownList in the Properties box be an acceptable alternative (it will not let the user pick anything that is not on the list)? -- Rick (MVP - Excel) "Boss" wrote in message ... Hi, I have dropdown (coprocess.List) which pulls data from below code... coprocess.List = ThisWorkbook.Sheets(1).Range("CL7:CL16").Value I wish it should give me a error or message when user puts something which is not in the drop down. Thanks! Boss |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to get a User Form to activate off a drop down menu | Excel Discussion (Misc queries) | |||
| Data Validation - Drop Down for User Form | Excel Discussion (Misc queries) | |||
| User Form - Get Data From Drop List | Excel Discussion (Misc queries) | |||
| Use a simple Drop Down List or User Form | Excel Programming | |||
| Data Input - User Form Drop-Down Box | Excel Programming | |||
Hybrid Mode
