View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael Vaughan Michael Vaughan is offline
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.