brothertruffle880
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
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.
If Val(SalaryEarnings.Value) <= 0 Or ___________
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.
Is this a textbox on a userform? Is SalaryEarnings the name of the textbox?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Martin Liss:
Yes. this a textbox on a userform and SalaryEarnings the name of the textbox
Yes. this a textbox on a userform and SalaryEarnings the name of the textbox
ASKER
Hi Martin Liss:
Yes. this a textbox on a userform and SalaryEarnings the name of the textbox
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?