logging with a username (vba)


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: logging with a username (vba)

  1. #1
    Join Date
    Apr 2005
    Posts
    1

    Question 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

  2. #2
    Join Date
    Mar 2005
    Posts
    110
    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
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center