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
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
Microsoft ExcelVBA
Last Comment
Dinesh Kumar
What are you trying to achieve? Would you elaborate your requirement?
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.
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.
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
This one is also solution from Expert exchange :)