Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
If you give your list a name (e.g., ID_Num), then you can place it on a
different worksheet. In the validated cell, set Source: =ID_Num. Bob "sebt" wrote: Oh and BTW, who had the bright idea of making data validation lists have to be on the same worksheet as the validated cell, in XL2003, when you could have them on any worksheet in XL2000? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem face in Validation Command (Pop-up Error Box) | Excel Worksheet Functions | |||
Command Button Error - Help Needed Urgently Please | Excel Worksheet Functions | |||
Error When Assigning a Macro to a Command Button | Excel Programming | |||
Command Button run-time error | Excel Programming | |||
Run-time error on command button | Excel Programming |