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
Bookmarks