If statement based on Text Box

[Sammy]

Hi,

I want an event to occur based on IF the user enters something in the text
box on my form.

I know how to do the opposite which would be "If ofrmMyForm.Text = "" Then"

I've tried using Null, I've tried the MaxLength, nothing seems to work.

Thanks for any advice.

 

[Russ]

If Not ofrmMyForm.Text = "" then...

Is that what you are asking

Len() gives number of characters

There is also a change_event for userform textboxes.

 

[Sammy]

That did the trick! Thank you

If Not ofrmMyForm.Text = "" then...

Is that what you are asking

Len() gives number of characters

There is also a change_event for userform textboxes.