How to prevent the code execution if a textbox is empty?

Question

I want to prevent the code execution if user leave a textbox empty

If tx01.Value = "" Then Exit Sub
If tx01.Value = vbNullString Then Exit Sub  //  also tried

But user can simply write a space (or any number of spaces) and - prevention doesn't work.
I need characters in this box (numeric and nonNumeric), but not only spaces.
How can I do this, pls ?

Tony Hopkinson · Accepted Answer · 2012-09-11 12:00:33Z

4

something like

if trim(tx01.Value) = "" then Exit sub

Trim removes leading and trailing whitespace characters.

answered Sep 11, 2012 at 12:00

Tony Hopkinson

20.4k3 gold badges35 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Alegro Over a year ago

Yes, that's it. ThankYoy - Tony and Ratan.

A Developer · Accepted Answer · 2012-09-11 11:58:02Z

4

Try adding a Trim() in the textbox value check.

answered Sep 11, 2012 at 11:58

A Developer

1,0313 gold badges15 silver badges33 bronze badges

Collectives™ on Stack Overflow

How to prevent the code execution if a textbox is empty?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related