Results 1 to 6 of 6

Selecting Optionbutton using VBA

Threaded View

  1. #1
    Registered User
    Join Date
    10-04-2008
    Location
    New York
    Posts
    7

    Selecting Optionbutton using VBA

    I have two option buttons on each of five spreadsheets in my Excel workbook.

    Selecting the first option button enables an x to be written to a cell when that cell is clicked with the mouse.

    Selecting the second option button disables the writing of the x when the cell is clicked with the mouse.

    I have these working quite well.

    My problem is that I want the second option button selected (disable writing of x) when I enter the sheet. I'm pretty certain that I need the code in Sub Worksheet_Activate() but I haven't been able to find the VBA statement to set the second option button on.

    Also, unlike having the option buttons on a form, when I select the option button on the spreadsheet in Design mode I can see no property sheet indicating the name, value, etc of the option button.
    Last edited by dwinmac; 10-05-2008 at 10:32 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Locating and selecting a column with VB Script
    By bigtonyicu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-24-2008, 02:17 PM
  2. Selecting All Buttons
    By jonn in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-28-2007, 09:17 PM
  3. OptionButton Properties Descriptions ?
    By dpenny in forum Excel General
    Replies: 2
    Last Post: 04-16-2007, 08:18 PM
  4. OptionButton weird behavior
    By dpenny in forum Excel General
    Replies: 2
    Last Post: 04-16-2007, 08:06 PM
  5. Selecting a graph using macro
    By Dagwood2005 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-20-2007, 05:45 PM

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