References

I have a userform with two option buttons. I would like to specify the ControlSource of optionbutton1 to column "A" in a file called 'firms.xls'
I would then do the same with optionbutton2 to column "A" in a file called 'clients.xls.'

Re: References

Hi Drk,
You can set the controlsource for an optionbutton the same way you would a text box - e.g. me.optionbuttonname.controlsource = "A1"
However, as far as I know, you cannot set the controlsource in the Click event of an option button and I don't think you can set it to a cell in another workbook. You can set it to another worksheet using .controlsource = "Sheet1!A1" for example.
Hope that helps.
PS It may be that I've just never found the correct syntax for referring to another workbook!