comparing name
Sub test()
Dim name As String
name = InputBox("Please write your name below")
If name = "xyz" Then
MsgBox "matches"
Else
MsgBox "does not match"
End If
End Sub
Hi,
In the above progarm, when I type xyz in the input box, the name matches.
However, when I type XYZ, the name does not match. Irrespctive of whether I
type XYZ or xyz, the name should match. Can please someone point me in the
right direction.
Thanks,
Abhi
|