+ Reply to Thread
Results 1 to 4 of 4

login username & password save data to next sheet

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

    login username & password save data to next sheet

    r/sir
    please halp me

    i am create a excel sheet Name Daliy Sales Report & i am create a 4 user form in this sheet login sheet was hidden than i open the excel sheet the login sheet was displayed with login user form, than i am click on the create a new user the new user form was displayed & than i am click on the change password the change password user form was displayed than i am create a new user the new user information was saved on the (Setting sheet)
    ( coloums B44, C44, D44, E44, G44)
    i am create a 2 button on (home sheet) in this excel sheet 1. setting, 2. add new Customer, Than i am click on setting button the setting sheet was displayed than i am click on the add new customer button the add new customer user form was displayed than i fill all the information of the customer this will show on the home sheet customer address (I13 TO I25 COLOUMS ) in this user form this information was saved on the sales sheet

    Customer id was pickup on the setting sheet (C5 COLOUMS) or the customer id was change automatically, add new customer user form payment terms pickup on the setting sheet
    I am create a ( Home sheet) (D13 coloums ) drop down list than i am choose cash the cash customers name was displayed, than i am choose a company the company name was displayed, than i am choose a Govt. the Govt name was displayed

    ( Setting sheet) the admin login defult password was show on the ( coloum C40)

    IF YOU DO NOT UNDER STAND MY LANGUAGE
    I AM ATTACH THE EXCEL SHEET

    respected sir please see the attachment & create a vba to my excel sheet
    Attached Files Attached Files

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

    Re: login username & password save data to next sheet

    i am download the vba code form the internet but error on this vba code than i open the excel file the error was displayed "elish without if" & i am create a login
    user form was not displayed & now you can see the user form & vba code & correction all of the vba codes

    i am attach the excel file
    please compile the vba code
    Attached Files Attached Files

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

    Re: login username & password save data to next sheet

    i am download the vba code form the internet but error on this vba code than i open the excel file the error was displayed "elish without if" & i am create a login
    user form was not displayed & now you can see the user form & vba code & correction all of the vba codes

    i am attach the excel file
    please compile the vba code
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    03-12-2014
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    41

    Re: login username & password save data to next sheet

    Remove the 1 Else on top and the End if at the bottom and it should resolve your error issues.

+ 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. [SOLVED] VBA to open website and Login using username and password????
    By SLANE in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-02-2014, 08:24 AM
  2. Username and Password Login Dilemma
    By Kershree in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-08-2014, 07:59 AM
  3. Username/Password Login userform code
    By Nitefox in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-17-2014, 02:43 PM
  4. username and password login
    By dc123 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-17-2013, 08:38 AM
  5. Username and Password login in MS Excel 2010
    By beseda2004 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-03-2011, 03:45 PM

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