asked on

What is the Not Equal sign for VBA?

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

Refering to question - https://www.experts-exchange.com/questions/21899670/Excel-VBA-IF-function-question.html

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

THEN

open formError

Harisha M G

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

neelyjer

ASKER

I'm a jack@$$....

I meant to ask for the unhide function.

I ALREADY HAVE THENOT EQUAL TO!!!!

RAISING POINTS TO 250

Guy Hengel [angelIII / a3]

txtUserID <> value AND txtPassword <> value

--- or ---

not ( txtUserID = value or txtPassword = value )

Harisha M G

txtUserID.Visible = True

Harisha M G

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

neelyjer

ASKER

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.

Harisha M G

So, what is your problem ? :P

Harisha M G

If you want to hide another form, put the name of that form instead of Me...

fromLogin.Hide

neelyjer

ASKER

I need to unhide the form that I was hidden after incorrect userID. How do I unhide the form?

ASKER CERTIFIED SOLUTION

Harisha M G

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.