Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get values for Range.Validation dropdown from a second work
Does any one have the answer to how I can get the values ( e.g. namedRange )
for a range validation dropdown from a worksheet other that the sheet that contains the Range.Validation. Thanks Jimm |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get values for Range.Validation dropdown from a second work
Hi Jimm
If you use a named range for the validation dropdown it is working with a range from another worksheet http://www.contextures.com/xlDataVal02.html -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Jimm" wrote in message ... Does any one have the answer to how I can get the values ( e.g. namedRange ) for a range validation dropdown from a worksheet other that the sheet that contains the Range.Validation. Thanks Jimm |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get values for Range.Validation dropdown from a second
Hi Ron,
Thanks for the quick response.... That works if the worksheet exists at design time - I guess what I'm trying to do is add another worksheet at runtime and then try to set a range to select from - it seems that the worksheet that gets added at run is not of the same type as the worksheet that is added at design time. Any idea how this can be gotten around or am I stuck having to have a 'data' sheet added at design time for my lookups use. Jimm "Ron de Bruin" wrote: Hi Jimm If you use a named range for the validation dropdown it is working with a range from another worksheet http://www.contextures.com/xlDataVal02.html -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Jimm" wrote in message ... Does any one have the answer to how I can get the values ( e.g. namedRange ) for a range validation dropdown from a worksheet other that the sheet that contains the Range.Validation. Thanks Jimm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data validation, totaling values based off dropdown lists | Excel Discussion (Misc queries) | |||
Validation-dropdown | Excel Discussion (Misc queries) | |||
Dropdown List from values in a Cell Range | Excel Programming | |||
Data Validation based on range of values | Excel Programming | |||
dropdown with validation?? | Excel Worksheet Functions |