Hello fellow members,
I have a problem with making a password in Excel using VBA.
Can one of you help me?
I have enclosed the file.
The start up file i have disabled because the Excelscreen would be invisible.
Please Login or Register to view this content.
Last edited by Richard Buttrey; 01-13-2019 at 08:05 PM. Reason: missing / on CODE tag
Perhaps you could explain what the code is not doing that you expect it to do. What I see is that you compare the values of two text boxes and then compare the value of one of those text boxes to a string value. If all three match then the worksheet is activated, else exit the application. I don't see a problem in the code.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
@blake,
Thanks for adding the code tags, so many don't. You missed the / from the [/CODE] tag which suggests you manually entered the tags. Always use the hash # key to generate the tags.
I edited your original.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
For starters I suppose the red text should be txtWachtWoord .Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Dank je wel bakerman2 (RC) ik keek er geheel overheen.
thanks bakerman2 for your correct input again.
Graag gedaan.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks