troubleshooting Question

VBA global variable lotus notes issue

Avatar of bfreescott
bfreescottFlag for United States of America asked on
Lotus IBMMicrosoft Excel
3 Comments1 Solution349 ViewsLast Modified:
Hi all,

I have an application that interacts heavily with Lotus Notes (email, databases, etc.) and I need to validate the user's Notes client (id file) password.  I have a userform that initializes when my app starts and a textbox for the password.  I declared the password variable globally because I want to be able to access it as many times as necessary until the app is closed.  The problem seems to be that the variable is destroyed when the form is hidden. Bear in mind, I am not unloading the form, simply hiding it, so I don't know why my variable will not retain the value from the textbox.

Thanks in advance for your help!!
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 3 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros