String=String

Hi,
Just a quicky, How do I compare 2 strings? I've just started in VBA and not quite use to the syntax. Here's the code I've done so far and works up to the point where it compares strings.

PHP Code: 

Public Function fShowMsg()
Dim Pass_Word As String
Dim sh As String
Pass_Word = "jon"
fShowMsg = MsgBox("Do you know the code?", vbYesNo)
If fShowMsg = vbYes Then
sh = InputBox("Enter the Password")
If Pass_Word = st Then
MsgBox ("Hello.")
End If
MsgBox ("Sorry that was incorrect, please contact creator.")
End If
End Function 


It's only a rough function at the moment, so probably lots of errors.

What you did was fine, except for the typo:

Please Login or Register  to view this content.

If you put Option Explicit at the top of all your modules, it will require you to declare all variables, which is good practice and would have caught this error at compile time.

Why are you using Function?