EXCEL EXPERT please attend.?

Question

Is it possible to open the form first before opening the my excel file?

I have created a form in excel using its vb, some sort of a welcome form, I want to open the excel file upon entering the loagin Id as "abcd" and password "defg". and pressing the enter command button what code must I write to accomplish this thing?
I know there is a built in function in excel to do this, But I want a vb form!
Please help me a code form has two text boxes for login ID and password, two button for enter and exit.
I also want a message box appear "You have entered invalid password/login id please try again' when enter button is pressed but with incorrect login id or paswword.
what code will i write to:
1. Textboxlogin name fi any,
2. Textbox password if any,
3. exit button,
4. enter button.

Thanks...

Answer 1

I'm sure it's possible. try the following
1 : Take course note
2 : Read aforementioned notes
3 : Read associated books
4 : Ask tutor if stuck
5 : Do OWN HOMEWORK !

Answer 2

nicely it relies upon, is that this username and password going to be difficult coded, or have a database back end? If its difficult coded then it may be some thing like deepest sub exit_click go out sub deepest sub login_click if msbox1.text fabric = username then goto userok else goto usernotok endif deepest sub userok if msbox2.text fabric = password then goto passok else goto usernotok endif deepest sub passok code right here that does despite the fact which you love to do if it works deepest sub usernotok msgbox ("Invalid person/bypass") go out sub it is off the right of my head so probable isnt precisely best even with the incontrovertible fact that this is close

Answer 3

This is a fairly complex thing to do. Please see the source link below.

-Jim

-Jim Gordon
Microsoft Mac MVP

MVPs are independent and do not work for Microsoft
http://mvp.support.microsoft.com/

Answer 4

contact on [e-mail]