If Username is not true then open a userform

[Wicked_]

Hi.

We got a excel program, which uses:

Worksheets("39").Range("Z100").Value = Environ("Username")

with adds the users usernames into a cell (Z100), which customizes their experience depening on who they are (userform).

But i am wondering.
Is there a way to add it so, if a user which is not "registered" in my sheet, it will instead open another userform?

Not quite sure how it should be written.

Basicly, if username does not match with the ones who are registered, then open a other userform.

Anyone knows how to do this?

Thanks

 

[steve the fish]

This should help if you adapt it to suit:

If IsError(Application.Match(Environ("username"), Sheets("Sheet1").Columns(1), 0)) Then
    MsgBox "no match"
Else
    MsgBox "match"
End If

 

[Wicked_]

Cheers.

I will try that out