maximilianshade
New Member
- Joined
- Jun 22, 2006
- Messages
- 9
I have a rather odd question that I hope someone can help me with.
For this scenario, please assume the following:
There is a named range 'Countries', that contains cells 'A1:A10' on sheet 'Validation Tables'.
There is a cell, B1, on a different sheet, that is using Data Validation to provide a drop down list limited to the items in the named range 'Countries'.
In this example, assume a user selects the drop down list, and selects 'USA', which is located specifically on cell 'A4' on sheet 'Validation Tables'
What I need to know is, via VBA, during an event which is firing on B1 changing, is there any way to KNOW which cell (in this case A4) corresponds to the selected item in the drop down list?
For this scenario, please assume the following:
There is a named range 'Countries', that contains cells 'A1:A10' on sheet 'Validation Tables'.
There is a cell, B1, on a different sheet, that is using Data Validation to provide a drop down list limited to the items in the named range 'Countries'.
In this example, assume a user selects the drop down list, and selects 'USA', which is located specifically on cell 'A4' on sheet 'Validation Tables'
What I need to know is, via VBA, during an event which is firing on B1 changing, is there any way to KNOW which cell (in this case A4) corresponds to the selected item in the drop down list?