Selection of Optionbutton control population of data in combobox

Hi everyone, this is my first post together being very green when it comes to VBA, so please be gentle

Basically I'd like to achieve this: depending upon the whether optionbutton1 or optionbutton2 is selected one of two different and seperate lists are viewed as the options in combobox1.

Everything is on the same Ssheet and the two lists are in the ranges "X2:X5" for optionbutton1 and "AA2:AA8" for optionbutton2

I've had a number of goes at the VB but not got very far so don't really feel its worth showing the level of code that I have so far. Though it might be better to start from first principles?

I hope I have given enough information?

Regards

Paul

Hi mehmetcik,

Thank you very much that has solved it. Most appreciated!!

Cheers

Paul