+ Reply to Thread
Results 1 to 9 of 9

Press Enter & Login to Excel Sheet

  1. #1
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    Press Enter & Login to Excel Sheet

    R/sir
    this file was working fine than today morning i will open the file the error was display " Run time error '9' Subscript Out of Range please resolve this error , i am create a three user form 'Admin Login', ' Change Password', 'Add User', this vba code was working fine than i open the excel sheet the login user form was display than i am add user name & password & press enter this was not working than i am use mouse & press login with mouse this was working fine & than i am Click on the Add user Button the Add user User Form was display & fill all the information & press enter this was not working than i am open the excel sheet the Admin login user Form was display & fill the Username & Password & press the enter from the keyboard this was login to the excel sheet
    than i am Click on the Add user Button the Add user User Form was display & fill all the information & press enter from the keyboard this was add new user & Than press the exit Button Only the Add User User Form Was Close not exit This excel sheet i add the Vba code for Remove Title Bar this code was Remove The Title Bar for 3 user form 'Admin Login', ' Change Password', 'Add User', but this code was not Remove the Title bar For Following User Forms "Add Customer, Add Purchase, Daily Expanses" please correction All the error in this Files i am resend the Attachments now you can see the attachments & resolve the Problem
    Thanking You
    Attached Files Attached Files

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Press Enter & Login to Excel Sheet

    Run time error '9 occurred because someone renamed the Invoice sheet as spaceinvoice (i.e.) " Invoice" instead of "Invoice"


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    Re: Press Enter & Login to Excel Sheet

    thanks " Run time error '9' Subscript Out of Range this problem was resolve & the Excel sheet was working fine the login password is '1234' now you can resolve my next problem in this excel sheet
    i am create a 7 user form name 'Add_Purchase, Daily_Expenditure,fCalendar,FrmAdmin,FrmChangePassword,FrmLogin,New_Customer'i am insert a Remove Title Bar Vba Code This Vba Code Was Remove Only 3 User Form Title Bar Name'FrmAdmin,FrmChangePassword,FrmLogin please correction in this Vba Code To remove the All 7 User Form title Barthan i open the excel sheet the login user form was display than i am fill user name & password & press enter From the Key Board this was not working than i am use
    mouse & press login with mouse this was working fine & than i am Click on the Add user Button the Add user User Form was display & fill all the information & press
    enter this was not working than i am use mouse & press login with mouse this was working fine & i am click on the exit button on add user form the excel sheet was
    totally blank please resolve this problem than i am open the excel sheet & login user form was display & fill username & Password & press enter from the keyboard than login to the excel sheet i am resend the attachments this attachments was working fine thanking you & resolve the Press enter From Key Bard & Remove Title bar
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    Re: Press Enter & Login to Excel Sheet

    dear sir please resolve my last posted problem

  5. #5
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Press Enter & Login to Excel Sheet

    This will resolve the keyboard action issue and act same like mouse action

    Please Login or Register  to view this content.
    Please ask your question one by one by indicating all the references. Because I don't have much time to study all your code and understand the issue

  6. #6
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    Re: Press Enter & Login to Excel Sheet

    please see the attachments & solve my problem i am create a i am create a 7 user form name 'Add_Purchase, Daily_Expenditure,fCalendar,FrmAdmin,FrmChangePassword,FrmLogin,New_Customer' than i am open the excel sheet the 'FrmAdmin' user from was display then i am fill username & password & press enter from the key board this was not working than i am use the mouse key & press the login button this was login to the excel sheet please solve my problem than i press the enter button from the keyboard this was login to the excel sheet than i login to the excel sheet & press Add User button the Add new User user form was display than i fill all the information & press the enter key from the keyboard this was not working than i am use the mouse key & press change password this was working fine than i press the exit key in this user from the excel sheet was go blank please solve this problem than i am use the keyboard & press the enter button this was working in all the user forms thanking you please see the attachments & solve the problem

  7. #7
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Press Enter & Login to Excel Sheet

    It seems that you have not implemented and read my Post #5 content

  8. #8
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    Re: Press Enter & Login to Excel Sheet

    R/ sir please reply whare i can paste this code
    Private Sub TxtPassword_Exit(ByVal Cancel As MSForms.ReturnBoolean)
    Call Image1_Click
    End Sub

  9. #9
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Press Enter & Login to Excel Sheet

    Double click your userform and you will get the userform code area just paste it and check

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 02-23-2013, 08:25 AM
  2. [SOLVED] keep having to press enter
    By louise2613 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-18-2012, 09:22 AM
  3. Macro to make Excel press F2 and Enter for me a bunch of times
    By nicelyj2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-17-2012, 08:17 AM
  4. Putting a Login name and ID to enter Excel Sheet
    By Shibu_john1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-17-2010, 08:29 AM
  5. [SOLVED] When I Press the Enter Key Nothing happens.
    By bigev in forum Excel General
    Replies: 1
    Last Post: 03-01-2006, 11:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1