Results 1 to 3 of 3

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

Threaded View

rain4u Macro to select/tick certain... 06-05-2011, 07:52 AM
pike Re: Macro to select/tick... 06-05-2011, 08:03 AM
rain4u Re: Macro to select/tick... 06-05-2011, 08:40 AM
  1. #1
    Forum Contributor
    Join Date
    01-29-2011
    Location
    Bristol, England
    MS-Off Ver
    Excel 2003
    Posts
    471

    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
    Last edited by rain4u; 06-05-2011 at 08:41 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1