Macro to select/tick certain ActiveX OptionButton (radio button)

Hi all
On my sheet I have x4 ActiveX option buttons or radio buttons if you prefer. They are OptionButton1, OptionButton2, OptionButton3 and OptionButton4. I just need a line that will select certain button at the end of my macro. I would like the macro to select OptionButton1. So after running my macro that button would have the little dot inside. Otherwise it will sit on the last one user had selected. I Googled around and did see some codes that could do this with Form option buttons but I couldn't find any that would apply ActiveX button. Anyone knows how to do this?


Any help is appreciated
Cheers
Rain

hi rain4u

you can modify

Please Login or Register  to view this content.