• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 52
  • Last Modified:

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
0
Dinesh Kumar
Asked:
Dinesh Kumar
  • 3
1 Solution
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
What are you trying to achieve? Would you elaborate your requirement?
0
 
Dinesh KumarAuthor Commented:
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.
0
 
Nandu 45Commented:
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
0
 
Dinesh KumarAuthor Commented:
my question is getting answered by patrickab in following question:

https://www.experts-exchange.com/questions/26818311/Password-Mask-in-INPUT-BOX-for-VBA.html
0
 
Dinesh KumarAuthor Commented:
This one is also solution from Expert exchange :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now