-
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
|
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL
|
Bookmarks