LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 71
Default Qn: Checkbox Enable??

Hello Everyone,

I have an checkbox option in my userform. How do I get it to blank or GRAY
out a TextBox area when the box is checked?? I saw a sample of how to
UNBLANK a textbox with the enable feature, but I need the opposite. What is
the opposite of enable?

a..
1.. Insert the following statement as the body of the new chkMonth_Click
procedu
b.. txtMonth.Enabled = chkMonth.Value
c.. This statement will enable the text box whenever the check box is
selected, and disable the text box whenever the check box is cleared.




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HOW TO DO ENABLE ENABLE THE QUERY PARAMETER BUTTON? CPW Excel Worksheet Functions 1 January 21st 10 06:31 PM
How to enable to click a checkbox? Eric Excel Discussion (Misc queries) 2 May 6th 09 03:54 PM
How to have Checkbox A uncheck with checked Checkbox B Texas Aggie Excel Discussion (Misc queries) 3 July 20th 07 10:58 PM
Checkbox!! Oppy Excel Discussion (Misc queries) 2 October 14th 05 05:28 PM
Checkbox Luke Excel Discussion (Misc queries) 1 October 14th 05 01:58 PM


All times are GMT +1. The time now is 08:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"