Link to home
Start Free TrialLog in
Avatar of brothertruffle880
brothertruffle880Flag for United States of America

asked on

Excel 2010 - Testing Textbox contents. "Less than zero" or "nothing was input into the textbox"

I have a textbox and would like to test the contents for values less than or equal to zero, or if the field was not even visited by the user

If Val(SalaryEarnings.Value) <= 0 Or ___________

Open in new window


What do I put where the underline is?  ""  or " "  or something else.
I want to test a textbox where the user didn't even click inside of it.
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Is this a textbox on a userform? Is SalaryEarnings the name of the textbox?
ASKER CERTIFIED SOLUTION
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of brothertruffle880

ASKER

Hi Martin Liss:
Yes.  this a textbox on a userform and SalaryEarnings the name of the textbox
Hi Martin Liss:
 Yes.  this a textbox on a userform and SalaryEarnings the name of the textbox
Is there something wrong with Neeraj's solution? If so, what?