*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