I have a text box and a check box on userform... how to make one change reflect the other object

[kbishop94]

userform activex objects;

my code; not working... "object required" error (I have also tried putting "Me." in front of the object names

Private Sub chkBOX_Click()
[COLOR=#008000]'[B] If CHECKBOX field is checked (Yes), then clear the TEXTBOX field contents:[/B][/COLOR]
If chkBOX = True Then txtBOX.Value = Null Else
End Sub


Private Sub txtBOX_Change()
[B][COLOR=#008000] is[/COLOR][COLOR=#008000]' If TEXTBOX field is NOT NULL (contains at least 1 ccharacter of something, then clear the CHECKBOX so it[/COLOR][/B][COLOR=#008000] [B]NULL:[/B][/COLOR]
If txtBOX.Value Is Not Null Then chkBOX = Null Else
End Sub

What I am wanting to do is this:

WHen something is typed into the text field, it automatically clears the checkbox beside it.

So basically when the checkbox is checked, it clears the corresponding textbox of any contents;
If anything IS typed in the textbox, then it clears the checkbox. (one affects the other.)

Like I said, I am getting an error with the above code. THanks for any help.

 

[Fluff]

Try

Private Sub txtBOX_Change()
If txtBox.Value <> "" Then chkBox = False
End Sub

 

[kbishop94]

Awesome (and so simple )
Thank you, Fluff

 

[Fluff]

Glad to help & thanks for the feedback