+ Reply to Thread
Results 1 to 4 of 4

Command button grayed out till option button selected

  1. #1
    Registered User
    Join Date
    08-11-2012
    Location
    Bay City, MI
    MS-Off Ver
    Excel 2010
    Posts
    2

    Question Command button grayed out till option button selected

    Hello, I'm new to this forum and this is my first post. I would like help with something I can't figure out, when my form opens I'd like the submit button grayed out until an option button selected. Thank you for your help in advance.

  2. #2
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Command button grayed out till option button selected

    Change the default 'enabled' property for the button (in the properties window) to false, or
    Please Login or Register  to view this content.
    in the forms initialization event. Then in the option buttons click event:
    Please Login or Register  to view this content.
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."

  3. #3
    Registered User
    Join Date
    08-11-2012
    Location
    Bay City, MI
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Command button grayed out till option button selected

    Thank you XeRo Solus, that works great.

  4. #4
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Command button grayed out till option button selected

    No problem. And welcome to the forum.

    If you are satisfied with the solution, please mark the thread as [SOLVED] by clicking the 'Thead Tools' drop down at the top of the thread.

    And you can always say thank you to those who have helped you by adding reputation. To add reputation click the * below the post of anyone who helped you.

+ 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. Help with command button to Save/Lock/Email when the "completed" button is selected.
    By testing the water in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-09-2013, 04:06 PM
  2. Uncheck Check Box + check a option button using Command Button
    By Carlsbergen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-21-2009, 03:09 AM
  3. selected option button assign 1 to a cell and others 0
    By hjk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-16-2007, 03:27 PM
  4. Option Button - multiple selected
    By alanap in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-17-2006, 06:10 PM
  5. If option button not selected
    By Hywel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-08-2005, 05:32 AM

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