Option Button: VBA Code to impact which dropdown list is used in a cell

[Rana Gray]

Hey Everyone!

Here I am again... I am not entirely sure this is possible but let me try to explain what I'm looking to code:

I have 2 option buttons: Canada [Op1] & USA [Op2]

I have a Drop Down List with all provinces listed and states in cell G33. What I want is for only the provinces to show when Canada is selected and only the states to show when USA is selected. Is this possible?

As always Thanks a Bunch in advance!!

 

[Hyakkivn]

Post your sheet here, so we could imagine exactly what you want..

 

[Rana Gray]

Post your sheet here, so we could imagine exactly what you want..

So right now I have a normal drop down list in G33 what I want is for that drop down to change based on whether Canada or USA is selected - I hope this helps!

 

[Rana Gray]

And by change I mean only show provinces vs states

 

[Rana Gray]

I figured it out!! Thank you!

Private Sub OptionButton1_Click()
ComboBox1.Value = ""
ComboBox1.ListFillRange = Sheet3.Range("I85:I97").Address(, , , True)
End Sub

Private Sub OptionButton2_Click()
ComboBox1.Value = ""
ComboBox1.ListFillRange = Sheet3.Range("J85:J134").Address(, , , True)
End Sub