Excel Userform Checkbox and Textbox relationship

[spycein]

Hi Everyone,

I have a userform which has checkbox and texbox.

I want link these boxes, i.e. if i tick the checkbox then only the textbox should be activated and i can fill the data in the textbox. Otherwise the textbox should remain deactivated and wont allow me to type anything.

I also want to know,How to make all fields mandatory in the userform.

Any fields cannot be left blank during entry, otherwise you cannot add the data.

Thanks a lot in advance

Regards
Shib

 

[mikerickson]

This should do the enabling of the TextBox

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