+ Reply to Thread
Results 1 to 5 of 5

Userform to recall values for option buttons

  1. #1
    Registered User
    Join Date
    08-14-2012
    Location
    Mumbai
    MS-Off Ver
    Excel 2010
    Posts
    3

    Userform to recall values for option buttons

    Hello

    I have a userform form wherein some values are recalled and some data needs to be feeded. Within Data that needs to be feeded thru userform I have 2 Option buttons as "Yes" (OptYes) & "No" (OptNo). The Option selected gets fed into a column. What i am looking is that if the cell is blank then the userform should display both the option buttons as False, Else if "Yes" is there in cell the it shall select option button "Yes" (OptYes) and vis-a-versa. Currently when the cell is blank (i.e. it has no value) the userform is selecting "No" as default. Below is the code for reference:
    Please Login or Register  to view this content.
    Where Dim OB as variant
    Dim Fnd as Range
    Last edited by rohit.rp; 08-17-2015 at 06:08 AM.

  2. #2
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,467

    Re: Userform to recall values for option buttons

    Hi there,

    Try:

    Please Login or Register  to view this content.
    Hope this helps - please let me know how you get on.

    Regards,

    Greg M

  3. #3
    Registered User
    Join Date
    08-14-2012
    Location
    Mumbai
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Userform to recall values for option buttons

    Thanks Greg for the reply.
    I did try amending as per your code, but no luck. Its showing as "No" enabled for blank cells.

  4. #4
    Registered User
    Join Date
    08-14-2012
    Location
    Mumbai
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Userform to recall values for option buttons

    Apoligies Greg, your code is working absolutely fine. I just missed to remove OB from the first line (removed it from the rest of the lines)
    Thanks a lot for your help.

  5. #5
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,467

    Re: Userform to recall values for option buttons

    Hi again,

    Many thanks for your feedback and also for the Reputation increase

    You're very welcome - I'm pleased that I was able to help.

    Best regards,

    Greg M

+ 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. Multiple Option Buttons in Userform
    By cmonstuh in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-19-2018, 07:48 AM
  2. [SOLVED] Option buttons and Image (userform)
    By kasharis in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-07-2014, 07:10 AM
  3. [SOLVED] Option Box buttons in UserForm help
    By motolich in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-28-2013, 12:04 AM
  4. Have Userform Recall Cell Values when form is reopened
    By kicker850 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-30-2013, 03:12 PM
  5. Userform Summing Option buttons
    By flebber in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 09-23-2010, 08:21 AM
  6. userform with frame and option buttons
    By erich_7719 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-25-2008, 11:57 AM
  7. Help with a option buttons located in a userform
    By mav93 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-01-2006, 01:40 PM

Tags for this Thread

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