Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to add validation by VBA
I want to set validation of a cell from a list of value in another exce
file. I know that I can do from Data Menu - Validation. However, want to do it by writing VBA code. Example: In A.xls, cell A1 = Apple cell A2 = Orange cell A3 = Pear cell A4 = Banana Then in B.xls, I want to set cell D3 can have the value only from th above list, How can I do so? Thx a lot -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to add validation by VBA
You cannot do this directly since datavalidation does not accept it.
HOWEVER, you can name the range in the active workbook that refers to the range in the source workbook. insertnamedefinename it mylistin the refers to box type in '=[20010112.xls]Data!$A$14:$A$19 now in the data validation cell use LIST and type in =mylist voila! -- Don Guillett SalesAid Software "michelle_ho " wrote in message ... I want to set validation of a cell from a list of value in another excel file. I know that I can do from Data Menu - Validation. However, I want to do it by writing VBA code. Example: In A.xls, cell A1 = Apple cell A2 = Orange cell A3 = Pear cell A4 = Banana Then in B.xls, I want to set cell D3 can have the value only from the above list, How can I do so? Thx a lot! --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
How do I get a Data validation list to select another validation l | New Users to Excel | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) |