Hello,
I am trying to build a combobox that will return one of four lists based on the input of another cell. Here is the code im writing however I dont believe i have the correct syntax. Thanks in advance for anyone's suggestions.
Code
Sub Pick_Reg()
Dim RegVal As String
RegVal = Worksheets("Main Template").Cells(B1).Value
Select Case RegVal
Case "Asia"
ComboBox("drpCountry").List = Worksheets("Main Template").Range("H306:H357")
Case "Europe"
ComboBox("drpCountry").List = Worksheets("Main Template").Range("H422:H541")
Case "Americas"
ComboBox("drpCountry").List = Worksheets("Main Template").Range("H358:H421")
Case "US"
ComboBox("drpCountry").List = Worksheets("Main Template").Range("H542")
End Select
End Sub
Display More