Advanced dropdown menu
Hi,
I want the dropdown to contain a list of company names, but when I choose the one I want the cell would show an acronym instead.
I.e. I choose "Microsoft" of the dropdown list, the cell will now show "MS".
So far I havent found anything that could solve this, but then I'm not the most experienced excel programer
(I have managed to make it showing an acronym in a different cell, but that would just make more clutter, wich is the opposite of what I'm trying to do)
Thanks for any help!
To do in one cell you will need VBA Change Event on Validation cell or use say an Active X Combo Box Control rather than Validation
Last edited by DonkeyOte; 11-12-2009 at 03:48 AM. Reason: .
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks