| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validation
Hi, Does anyone know how to define a validation with VB? I have a number of named ranges (on a hidden validation sheet) that make up drop downs in my spreadsheet - I'd like to set these up from within a Macro. Any help would be great. Phil |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Validation
I think if you record a macro when you do it manually, you'll see what you
need. And you'll have the worksheet names, range names, and cells correct for your project. PW11111 wrote: Hi, Does anyone know how to define a validation with VB? I have a number of named ranges (on a hidden validation sheet) that make up drop downs in my spreadsheet - I'd like to set these up from within a Macro. Any help would be great. Phil -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
| Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
| Validation (Drop down list vs simple text length validation) | Excel Programming | |||
| Validation (Drop down list vs simple text length validation) | Excel Programming | |||
| Validation (Drop down list vs simple text length validation) | Excel Programming | |||
Linear Mode
