title: excel vba get address of cell linked to selection in data valuation drop down
body: <p>I have a data validation drop down list on sheet1 and the source of the list on sheet2. The data on sheet2 is a set of records, one per row. When a user makes a selection from the drop down I need to query the address of the cell that provided the data on sheet2. I am using the <code>Workbook_SheetChange()</code> function that for now just pops up a message box for testing. I want to transfer data from other columns in the list on sheet2 to sheet1 so what I need is the row reference on sheet2 of the data that was selected by the user on sheet1.</p>