What is the Not Equal sign for VBA?

Just need to know the not equal to symbol for programming in VBA.

Refering to question - http://www.experts-exchange.com/Applications/Q_21899670.html

the next step is to add an else if statement saying if txtUserID and txt UserPW is not equal to .....

THEN

open formError
neelyjerAsked:
Who is Participating?
 
Harisha M GConnect With a Mentor Commented:
frmLogin.Show
0
 
Harisha M GCommented:
<>
0
 
Harisha M GCommented:
neelyjer, you don't need to have ElseIf, instead, have Else

If(txtUserID = "Manager"...) Then
    ' Do something
ElseIf(txtUserID = "User"...) Then
    ' Do something else
Else
    ' Invalid username/password combination
End If
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
neelyjerAuthor Commented:
I'm a jack@$$....


I meant to ask for the unhide function.

I ALREADY HAVE THENOT EQUAL TO!!!!

RAISING POINTS TO 250
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
txtUserID <> value AND  txtPassword <> value

--- or ---

not ( txtUserID = value or  txtPassword = value )
0
 
Harisha M GCommented:
txtUserID.Visible = True
0
 
Harisha M GCommented:
Did I understand it properly ? What do you want to unhide ?

If you are asking to close the form after clicking Cancel,

Me.Hide  will do
0
 
neelyjerAuthor Commented:
Harish,

After entering an incorrect username and/or PW a the login for is hidden and a form opens displaying an error message.  After clicking OK on the error message, I am closing the error form - Unload Me - and unhiding the login form.
0
 
Harisha M GCommented:
So, what is your problem ? :P
0
 
Harisha M GCommented:
If you want to hide another form, put the name of that form instead of Me...

fromLogin.Hide
0
 
neelyjerAuthor Commented:
I need to unhide the form that I was hidden after incorrect userID.  How do I unhide the form?
0
 
neelyjerAuthor Commented:
Perfection.  I'm not a dentist but I think we could've pulled teeth quicker than that.
0
 
Harisha M GCommented:
:)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.