Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation Programming
Hello, Using excel 97, I currently have a drop down box which list locatio names. The problem is the location names are very generic (only part o the location info). What I would like to do is have a drop down lis actually list the full location name but populate the field with th generic name when selected. I could add another column but this fil will be used as import data and the extra field is not part of th extract layout. Ex. Generic name:T100 Full location name: Trumbull 100 (specific trumbull address) User's would select trumbull 100 from the drop down list, but the nam T100 would actually populate the field. I tried to reference th generic range but keep on getting a circular reference error. Can thi be done -- pyar ----------------------------------------------------------------------- pyarb's Profile: http://www.excelforum.com/member.php...fo&userid=2680 View this thread: http://www.excelforum.com/showthread.php?threadid=40148 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom data validation on cells with data validation values | Excel Worksheet Functions | |||
Excel 2007-macro programming logic for data validation | Excel Discussion (Misc queries) | |||
Excel 2007-programming macros that apply to data validation | New Users to Excel | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) |