+ Reply to Thread
Results 1 to 14 of 14

option button to disable textbox

  1. #1
    Registered User
    Join Date
    10-14-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    78

    option button to disable textbox

    Hi
    can someone please help with this one. I have two option buttons "satisfactory" and "unsatisfactory" and one text box "txttext" I need the "txttext" to be disabled as default as the option button "satisfactory" will be set to default and then active when "unsatisfactory" option button is chosen.

    thanks if you can help

  2. #2
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,011

    Re: option button to disable textbox

    will u plz upload a sample file

  3. #3
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,011

    Re: option button to disable textbox

    try this
    Please Login or Register  to view this content.
    if u like than use star
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    10-14-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    78

    Re: option button to disable textbox

    Thanks that excellent, is there a way of having the texbox looking like its disabled with a greyish colour and then white when active.

    thanks again

  5. #5
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,011

    Re: option button to disable textbox

    hi, molesy

    if u click satisfactory than textbox's value will fade automatically, but about textbox color don't know

  6. #6
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,011

    Re: option button to disable textbox

    try this

    Please Login or Register  to view this content.

  7. #7
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,011

    Re: option button to disable textbox

    or try this

    Please Login or Register  to view this content.

  8. #8
    Registered User
    Join Date
    10-14-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    78

    Re: option button to disable textbox

    Hi
    Thanks i got the colour to work

    txttext.BackColor = RGB(192, 192, 192)

    but i am stuck trying to get the satisfactory button to show checked when form is initialized. the textbox is disabled but i would like the button to show its checked.

  9. #9
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,011

    Re: option button to disable textbox

    by default u want to satisfactory button to show checked

  10. #10
    Registered User
    Join Date
    10-14-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    78

    Re: option button to disable textbox

    yes please

  11. #11
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,011

    Re: option button to disable textbox

    try this

    Please Login or Register  to view this content.

  12. #12
    Registered User
    Join Date
    10-14-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    78

    Re: option button to disable textbox

    thanks it all works

  13. #13
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,011

    Re: option button to disable textbox

    happy to help, thanx for feedback

  14. #14
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,011

    Re: option button to disable textbox

    if u like answer than use the star button

+ 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] Disable option button on user form??????
    By Bflare in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 01-27-2014, 04:42 PM
  2. Using an Option Button to send a textbox value to a cell
    By JChaney17 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-06-2013, 11:24 PM
  3. Disable cells contingent on an option button
    By jghender in forum Excel General
    Replies: 0
    Last Post: 12-27-2012, 06:10 PM
  4. [SOLVED] passing Option button result to textbox
    By tigerdel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-29-2012, 02:35 AM
  5. How to Enable/Disable the Option Button(s) based on different ComboBox Values?
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-30-2011, 04:32 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