Link to home
Create AccountLog in
Avatar of Dinesh Kumar
Dinesh KumarFlag for India

asked on

VBA login Page

Hi Experts,

I needed to show a login dialog box where it will ask for username and password and capture them in VBA.

How can I do this.

Thanks in advance.

Thanks
meetDinesh
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

What are you trying to achieve? Would you elaborate your requirement?
Avatar of Dinesh Kumar

ASKER

Sure, Its kind of authentication I want to have in Excel.

e.g. I am getting data from webbservice so that webservice  authenicates the user/pwd before sending any data.  right now I have written user/pwd in sheet3 in B1 and B2 cells but now I am asked to have dialog box to get this information so it will be like following:

1. press submit button.
2. the dialog box will appear.
3.  I will put the user/pwd
4. this information will go to the webserivce
5. after successful authentication I will get the data.

Please let me know if  more inputs are required.
Avatar of Nandu 45
Nandu 45

I am getting data from webbservice so that webservice  authenicates the user/pwd before sending any data.  right now I have written user/pwd in sheet3 in B1 and B2 cells but now I am asked to have dialog box to get this information so it will be like
ASKER CERTIFIED SOLUTION
Avatar of Dinesh Kumar
Dinesh Kumar
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
This one is also solution from Expert exchange :)