Option buttons transfer to Excel Option buttons

[Celica]

Hi

I want to transfer the userform option buttons over to excel's option buttons, with what was already selected, How would I do that? I don't want the code to write what the user have selected. My attempt at this failed miserably.

I have created a command button and in this is where I've attempted the coding:

sheets("name of the sheet").select
optionbutton1 = UserForm1.OptionButton1.value
optionbutton2 = UserForm1.OptionButton2.value

Would appreciate your help.
Thanks

 

[tygrrboi]

have you tried


ActiveSheet.Shapes("Option Button 1").ControlFormat.Value = UserForm1.OptionButton1.value

 

[Celica]

Thanks tygrrboi, it worked!