Advanced Dropdown List (Impossible?)

[ksbartel]

I have searched all over for an example of this but have no luck, I think it may be impossible.

Essentially, I need the dropdown list to show different text than it puts in the box when you select it.

For example: I have 3 columns, column A is "Item #", Column B is "Description" and column C will have the dropdown menu that shows "Item # - Description" but when you select an entry, it only populates column C with the Item #.

I know this example seems stupid and trivial, but the goal was to get across the point, not the actual application.

Any help would be great, I would also be satisfied if you told me it is impossible

Thanks!

 

[Jerry Sullivan]

Hi ksbartel,

It's not impossible-that can be done with a Worksheet_Change event provided that you set your data validation to have no Error Alerts.

I've did this a while back using a 2-column named range. The first column held the values to show in the dropdown. The second column had the corresponding values to display.

Your application could be simpler, if it only requires parsing the dropdown label. That could happen inside the Worksheet_Change code without the need for a look up table.

If you want some help with the code, please give some more specifics related to your use.

 

[ksbartel]

Thanks for the reply JS411, sorry it took me so long to get back on here.

The problem with the solution is that I am not the predominant user of the application and that most people using it hate macros because they can't Ctrl+Z... I used to have a handful of worksheet_change events but I removed them because it took away the option to undoing...

No sweat, it isn't a big deal. I just wanted to confirm my theory that there isn't a 'good' way to do this easily.

Thanks again!