| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
the user that fills out the form needs to see 123 Apples, the end user
doesn't need to see it. What is an event change macro? "Biff" wrote in message ... Hi! If you have in your list: 123 apples 123 oranges How will you know what 123 refers to? This can probably be done with an event change macro. Biff -----Original Message----- hi all, I'm using excel 2000. Is there a way to have a drop down list that displays the full text, but upon selection only returns the first 3 characters? for example, in the list I have : 123 apples, 345 Oranges. I want the Users to see "123 apples", but when they choose it, only "123" is placed in the cell. TIA James . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| add option to drop down menu | Excel Discussion (Misc queries) | |||
| How to add a drop down menu to a cell | Excel Discussion (Misc queries) | |||
| drop down menu containing worksheet names | Excel Worksheet Functions | |||
| Applying a formula to a drop menu choice | Excel Discussion (Misc queries) | |||
| How do I set up a drop down menu for a validation list? | Excel Worksheet Functions | |||
Threaded Mode
