LinkBack URL
About LinkBacks
Hi Everyone,
Need to mask the password in the Message Box popup... unable to find good examples...
Any Thoughts???
Please Login or Register to view this content.
Best Regards,
John
Hi Everyone,
Need to mask the password in the Message Box popup... unable to find good examples...
Any Thoughts???Please Login or Register to view this content.
Best Regards,
John
Last edited by JJFletcher; 05-06-2016 at 09:42 PM.
Look at this link
http://www.ozgrid.com/forum/showthread.php?t=15848
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Use a userform.
Use a Textbox to enter the password
Use the keypress event to store the character and replace it with an asterix.
Your Macro becomes:-
Please Login or Register to view this content.
The Userform Code is:-
Please Login or Register to view this content.
This userform code is probably better, it is case sensitive wheras the previous one assumed capitals.:-
Please Login or Register to view this content.
Last edited by mehmetcik; 05-06-2016 at 04:00 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
The input box in the above code is generated by the macro - I think the solution you suggest works with Forms...
John
I would like to achieve this without using a form... I would like to use the macro above
John
Last edited by JJFletcher; 05-06-2016 at 03:44 PM. Reason: spelling
Ok. How about this:
http://www.mrexcel.com/archive/VBA/19882a.html
Since you chose to ignore my contributions, I no longer feel inclined to offer you any solutions.
This is one, For Example: http://www.excelforum.com/excel-prog...getions-2.html
What goes around, comes around my friend.
Please consider a more responsive attitude, and you could avoid an "Ignore List".
Regards.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
WINON,
You are JOKING right - you are referring to a post in 2007... Wow - Sorry WINON that I did not reply - I was new to the Forum then... Interesting you keep such a grudge for so long... what prompted this by the way...
John
Last edited by JJFletcher; 05-06-2016 at 04:41 PM.
Hi John,
I bear no grudge, and the Post I a referring to was in April 2016, and not 2007.
The Thread Topic is: Macro to change caption in Toggle button (Open/Close) code - Any Suggetions?
One of the responses was: BSB,
Thanks so much for your suggestions... The Toggle Buttons you both offered do work, however the size is just to big to fit into the sheet design...
Name: sample2.JPG Views: 4 Size: 11.2 KB
The Code I mentioned above works with the current button but the caption does not change...
John
I offered you a solution with a sample Workbook, with a request a couple of days later, asking you if it helped?
Does that ring a bell?
Regards.
Hi Winon,
My apologies to say the least!!!!!
It is not my intention to insult anyone, especially the Experts, Moderators and Forum Contributors which are extremely invaluable assets for all interested Excel Expert Coders and novices world wide. I encourage all who have a desire to learn and understand Excel to visit "THIS" Forum. I have been treated well here and I am sorry If I offended you in any way... The Post in which is referenced was overlooked and I am sorry for this... Hope this can be put aside
Best Regards,
John
No problem John,
There is nothing to put aside as things are sometimes overlooked. Thank you for not feeling offended by me for ruffling the feathers.
All is well!
Kind Regards.
Thanks Everyone...
It seems as though the Userform is the only real solution because a text box can only be Masked in a Userform.....
I have adopted this suggestion and it works fine!
Thanks much again,
Best Regards,
John
Although you have resolved your issue I would like to present this for future reference.
I came accross this a long time ago and it is in fact possible to mask InputBox input.
Thank you so much for your suggestion,
Unfortunately it did not work - it said that it needed to be updated to a 64 bit system and PFSafe settings needed to be added.
Best Regards,
John
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks