I'm trying to set up a feature in my workbook where a user can select an acronym anywhere on a spreadsheet and cell A1 will display the acronym selected. I'm planning to use the acronym appearing in A1 to display the spelled-out name in B1 via a lookup table.
For example, I'd like to set A1 equal to a currently selected text string. In this example, cell A2 has this text string in it: The CEO of ABC is John Smith.
I want to set A1 equal to any text string that I select. I click on A2 (making it the active cell) and select the acronym "CEO". I'd like A1 to instantly change its value to "CEO". I'll use CEO in a vlookup to set B1 equal to "Chief Executive Officer". Next, I select the acronym "ABC" in A2. I want A1 to instantly show a value of "ABC" (and B1 will instantly change to "American Broadcasting Corporation". And so on for any text string that I select anywhere on the spreadsheet.
I'm not trying to set A1 equal to the active cell's value -- this question was already answered in a thread back around 2006. I know that I can copy and paste the selected string into A1, but that involves extra steps. I don't want to use Smart Lookup (unless there is a way to customize Smart Lookup to just use my lookup table and not search the entire Internet). I just want to dynamically set A1 equal to the string that I have currently selected.
I'd appreciate any help on this.
For example, I'd like to set A1 equal to a currently selected text string. In this example, cell A2 has this text string in it: The CEO of ABC is John Smith.
I want to set A1 equal to any text string that I select. I click on A2 (making it the active cell) and select the acronym "CEO". I'd like A1 to instantly change its value to "CEO". I'll use CEO in a vlookup to set B1 equal to "Chief Executive Officer". Next, I select the acronym "ABC" in A2. I want A1 to instantly show a value of "ABC" (and B1 will instantly change to "American Broadcasting Corporation". And so on for any text string that I select anywhere on the spreadsheet.
I'm not trying to set A1 equal to the active cell's value -- this question was already answered in a thread back around 2006. I know that I can copy and paste the selected string into A1, but that involves extra steps. I don't want to use Smart Lookup (unless there is a way to customize Smart Lookup to just use my lookup table and not search the entire Internet). I just want to dynamically set A1 equal to the string that I have currently selected.
I'd appreciate any help on this.