+ Reply to Thread
Results 1 to 4 of 4

Option buttons on a user form

  1. #1
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    854

    Option buttons on a user form

    I have two option buttons on a user form named OptionButton1 & OptionButton2. When I select OptionButton1, I want the range name PBITtrigger to be equal to 1, and when I select OptionButton2, I want the range name PBITtrigger to be equal to 2. Can someone help with the code for this?
    Thanks in advance.

  2. #2
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    854

    Re: Option buttons on a user form

    I have decided to use option buttons in Excel and not on the user form & then link the button to the cell which works fine. I thought when I added the option buttons to the user form, and linked the button to the cell, I would get a value of 1 etc. instead of True. It would be nice to know how to do this when the buttons are on the user form though?

  3. #3
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Option buttons on a user form

    perhaps
    Please Login or Register  to view this content.
    or even
    Please Login or Register  to view this content.
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  4. #4
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    854

    Re: Option buttons on a user form

    Thank you Joseph. Much appreciated.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] User Form with option buttons
    By Aland2929 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-16-2013, 07:45 AM
  2. Replies: 5
    Last Post: 04-16-2011, 07:20 PM
  3. User form with option buttons
    By jalba in forum Excel General
    Replies: 1
    Last Post: 01-03-2011, 04:46 AM
  4. How to add option buttons from VB Form
    By bhagwat in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-05-2009, 06:42 AM
  5. User Form Option & Command Buttons
    By Information Hog in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-19-2005, 06:37 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