*File attached for reference
I am trying to write a large macro associated with the button on 'Sheet2'. First i need to identify the country that i select in the drop down as my 'index'. i am having trouble getting that to happen.
Then, after i define the country, i will then need to have the fields populated below with the information in the Data Field. The catch is that the amount of fields needed may vary from all 5, to only 1. I can use a "hide" function if needed, but was wondering if there was a better way.
Data for Drop down:
Sub Dorp_Down1() 'pull index Dim index As Integer Dim linkAddress As String Dim linkName As String index = ActiveSheet.Shapes(Application.Caller).ControlFormat.ListIndex + 1 'Country Header Sheets("Sheet1").Cells(3, 1) = Sheets("Market Hyperlink").Cells(index, 1).Value End Sub
Bookmarks