View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default Conditional Button Enabling based on Checkbox

Chip's code works perfectly for me. Are you sure you're following it exactly
and have provided all the information?

--

Vasant

"Todd Huttenstine" wrote in message
...
That still does not work properly. It works before I
check it, but after I check it and then take the check
out, I can still type in the box and its not supposed to
do that because there is no check in the box.


-----Original Message-----
Rule no 2: don't make it complicated.

At design time, set the enabled property of the textbox

to false, and the
value of the checkbox to unchecked.
Then add this code to the click event of the checkbox.

If Check1.Value = 1 Then
Text1.Enabled = True
Else
Text1.Enabled = False
End If


"Todd uttenstine"

wrote in message
...
I have CheckBox1 and TextBox1 on a UserForm. What is

the
code that would enable entry into TextBox1 if CheckBox1
has a check in it?

Thank you

Todd Huttenstine



.