another type mismatch

I'm inputting a txtUserFilename from a textbox. That's the name I gave the
textbox in its properties.

Here's the code I have:

Private Sub cmdNext_Click()

txtUserFilename = Trim(txtUserFilename)
If txtUserFilename = vbNullString Then
MsgBox "You Must Enter a Valid Filename", , "Enter File Name"
txtUserFilename.SetFocus
Exit Sub
End If

If txtUserFilename = "Asset" Or "asset" Then MsgBox "You Must Enter a Valid USER Filename", , "Enter File Name"
txtUserFilename.SetFocus
Exit Sub
End If
End Sub

I'm getting a type mismatch on the line: If txtUserFilename = "Asset.....
I've tried txtUserFilename.txt and .value but that's not it.

Hello Marcmarc,

The problem is with the "OR" operator. You must specify a another comparasion operator that evaluates to either TRUE or FLASE.

Try This...

Please Login or Register  to view this content.

If you want the code to be case insensitive you could simply use...

Please Login or Register  to view this content.

Sincerely,
Leith Ross

If it was a snake, it woulda bit me!
That did the trick!
Thank you, Leith
Marc