Start Free Trial
VBA login Page
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.
8/22/2022 - Mon
Subodh Tiwari (Neeraj)
What are you trying to achieve? Would you elaborate your requirement?
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.
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
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
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.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
This one is also solution from Expert exchange :)
Plans and Pricing
Certified Expert Program
© 1996-2023 Experts Exchange, LLC. All rights reserved. Covered by US Patent