ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Input box with asterisks (https://www.excelbanter.com/excel-discussion-misc-queries/104753-input-box-asterisks.html)

kjworks

Input box with asterisks
 
The user clicks on a button. The button brings up an inputbox, which asks the
user to enter a password. The user enters the password which can be seen.
How can the entry be masked by asterisks? This way if someone is standing
behind them when they enter their password only asterisks can be seen.

scottfoxall

Input box with asterisks
 
I may be wrong but I don't think that can be done with an Input box.

It can be done by creating your own input box and place the masking chr for
the textbox property PasswordChar

"kjworks" wrote:

The user clicks on a button. The button brings up an inputbox, which asks the
user to enter a password. The user enters the password which can be seen.
How can the entry be masked by asterisks? This way if someone is standing
behind them when they enter their password only asterisks can be seen.


Ken Johnson

Input box with asterisks
 

Hi Scott,

I was going to ask this question just last week but didn't get around
to it, then I spotted this one so bookmarked it.
Thanks for your response. Very useful information. My money's on you
being 100% corrrect about not being able to do it with the standard
InputBox.

Ken Johnson



All times are GMT +1. The time now is 03:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com