Populating ComboBox based on Option button in excel userform

[dotchieJack]

Hello
In an excel userform i have 3 option buttons
If i choose optionbutton 1 a combobox must be filled with range
Something like that

 ComboBox1.RowSource = Sheets("artikellijst").Range("K3:K9").Value

If i choose optionbutton 2 a combobox must be filled with range

 ComboBox1.RowSource = Sheets("artikellijst").Range("K10:K128").Value

If i choose optionbutton 3 a combobox must be filled with range

 ComboBox1.RowSource = Sheets("artikellijst").Range("K129:K184").Value

Any help welcome
Thanks

 

[shrivallabha]

Example event code for Optionbutton1 would be:

Private Sub OptionButton1_Click()
With Me
    .OptionButton2.Value = 0
    .OptionButton3.Value = 0
    .ComboBox1.RowSource = "Sheet1!A1:A5"
End With
End Sub

 

[dotchieJack]

Hello,
Thank you for your quick response
I have this now

Private Sub OptionButton1_Click()
With Me
  .OptionButton2.Value = 0
  .OptionButton3.Value = 0
  .ComboBox1.RowSource = "artikellijst!K3:K9"
End With
End Sub

But is does not populate the ComboBox

 

[shrivallabha]

Post your workbook.

 

[dotchieJack]

Hello
For some reason, i can not upload a file

 

[dotchieJack]

Hello,
Problem solved
Thanks

 

[shrivallabha]

Hello,
Problem solved
Thanks

Good to know. What was the issue?

 

[dotchieJack]

Hello,
I solved it with this

Private Sub OptionButton1_Click()
ListBox1.List = Worksheets("artikellijst").Range("A3:G11").Value
End Sub

it works with a combobox to
thanks for the help