How to Mask Password in MsgBox ???

[JJFletcher]

Hi Everyone,

Need to mask the password in the Message Box popup... unable to find good examples...

Please Login or Register  to view this content.

Any Thoughts???

Best Regards,

John

[alansidman]

Look at this link

http://www.ozgrid.com/forum/showthread.php?t=15848

[mehmetcik]

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.

[JJFletcher]

The input box in the above code is generated by the macro - I think the solution you suggest works with Forms...

John

[JJFletcher]

I would like to achieve this without using a form... I would like to use the macro above

John

[alansidman]

Ok. How about this:

http://www.mrexcel.com/archive/VBA/19882a.html

[Winon]

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.

[JJFletcher]

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

[Winon]

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.

[JJFletcher]

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

[Winon]

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.

[JJFletcher]

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

[bakerman2]

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.

[JJFletcher]

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