-
logging with a username (vba)
i need to create a logging name and password for a spreadsheet project am doing. i made this code in vba but it doesnt seen to work, it doesnt take me to the specified sheet and does not didplay the message. any help would be appreciated
Private Sub cmdClickme_Click()
On Error GoTo errorhandler
Dim varResponse As Variant
varResponse = InputBox("Enter your Name")
If varResponse = "name" Then
Sheet2.Select
MsgBox "message here"
Unload Me
frmMain.Show
errorhandler:
Else
MsgBox "Sorry Try Again!"
End If
End Sub
-
I tested your program. in my computer It works. no proplem.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Development Centers
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center
|