Greetings fellow guru's
I have a listbox with many entries. I need to be able to retrieve the Cell Address for any given listbox entry. Lets say my listbox has 1 Column of data. And its data is pulled from Range("A1:A3"). Like so...
A
1 Dog
2 Cat
3 Rat
I would like to be able to click Cat in the Listbox and have $A$2 stored as the range to be selected.
The Range will be used in a re-population Macro for a very large workbook. Imagine a revers lookup feature and that's the idea.
Thanks again for any insight.