| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Setting the Validation Criteria on the fly
Help!!
I have a WorkBook with a Sheet that contains lists that are defined as named ranges. I am using VB within Excel to build a sheet and want to set a cells validation criteria from the lists. For Example my Sheet called LISTS has a named range AI810 that has a list of values 0..20mA, 1..5V, 4..20mA When I insert a sheet using VB I want to set say cell A2 to the above validation criteria. I know if I do it by hand you use the =indirect("LISTS!AI810") and select a List. How do u do it from within VB |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiple data validation criteria | Excel Discussion (Misc queries) | |||
| Setting up a validation of data listbox to provide the unique items within a range | Excel Worksheet Functions | |||
| Data validation two criteria | Excel Worksheet Functions | |||
| Validation - multiple criteria in one cell | Excel Discussion (Misc queries) | |||
| Setting formula to give info from rows with certain criteria | Excel Worksheet Functions | |||
Threaded Mode
