View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
libby libby is offline
external usenet poster
 
Posts: 96
Default Conditional Button Enabling based on Checkbox


Private Sub CheckBox1_Click()
TextBox1.Enabled = CheckBox1.Value
End Sub


-----Original Message-----
I cannot get that method to work flawlessly. I think I
need an if then statement.


-----Original 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
.

.