+ Reply to Thread
Results 1 to 4 of 4

Form and radio buttons

Hybrid View

axm1955 Form and radio buttons 12-18-2017, 08:08 PM
gmr4evr1 Re: Form and radio buttons 12-18-2017, 08:19 PM
axm1955 Re: Form and radio buttons 12-22-2017, 10:33 AM
gmr4evr1 Re: Form and radio buttons 12-22-2017, 03:12 PM
  1. #1
    Registered User
    Join Date
    04-09-2014
    Location
    Chapel Hill, NC
    MS-Off Ver
    2010
    Posts
    7

    Form and radio buttons

    Hello all,

    I have several forms with questions and associated grouped radio button answers, the radio buttons are grouped so only 1 answer is selectable. Is there a way to make the button "highlighted" so that it can be space bar or or some other way selected?

    I can select the radio buttons perfectly fine for each question using the mouse and I can tab across the buttons, hitting the space bar selects the button, but, I have to count the tabs to know which button corresponds to what answer value I desire. Just wondering if it was possible to either shadow the button or highlight it to make it standout as to the current tab positioning.

    Many thanks to any assistance with this.

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Form and radio buttons

    maybe you could have it change the font color with..
    OptionButton1.ForeColor = vbRed
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

  3. #3
    Registered User
    Join Date
    04-09-2014
    Location
    Chapel Hill, NC
    MS-Off Ver
    2010
    Posts
    7

    Re: Form and radio buttons

    Not sure I understand the reply gmr4evr1, are you suggesting that as the focus moves from tab stop to tab stop I add a function to highlight the focused button? That would require a function for every button in a form, with some of my forms having up to 80 buttons in 20 groups I would have to write 80 exit test functions? Or perhaps I misunderstood your reply. Could you please provide me more info.....probably dense today.

    Thanks

  4. #4
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Form and radio buttons

    I was thinking more along the lines of looping through the OptionButtons to see if they have SetFocus. The problem is, I haven't been able to figure out how to get the macro to trigger.

+ 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. Conditioned radio-buttons form
    By udi1234 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-26-2014, 03:37 PM
  2. Replies: 0
    Last Post: 10-15-2013, 03:37 PM
  3. [SOLVED] Trying to place radio buttons using vba in a form. With a for next loop
    By Kammphoto in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-28-2013, 05:35 PM
  4. [SOLVED] Form w/ Textbox/Radio buttons/Checkbox and button to transfer to 2nd sheet as database
    By christlivethinme in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-27-2013, 02:24 PM
  5. Creating a Survey-Style Form Using Radio Buttons in Cells
    By antiSocialWorker in forum Excel General
    Replies: 1
    Last Post: 04-20-2012, 03:52 PM
  6. Form w/ Radio Buttons
    By eforti in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-12-2007, 05:11 PM
  7. [SOLVED] How can I reset an Excel form that has radio buttons.
    By JaxPM in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-03-2006, 11:00 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