This has come up a few times recently.
Whilst it's possible through a significant amount of complex coding to alter the built in input box, for most people it's the wrong solution. It's much easier and more flexible to use a simple userform, this workbook wraps the userform so that it can be used in the same way as an input box. As the most common requirement for this is to enter passwords without seeing what is being typed - this does so by default, using *.
It takes the following required parameter:
- Prompt - This what what you want to appear as the message content, this can be multi-line, the PasswordBox will re-size to accommodate the prompt
It accepts the following optional parameters:
- Title - The caption for the PasswordBox, the default is "Enter Password"
- OkButtonText - The caption the submit/OK button, the default is "Ok"
- CancelButtonText - The caption for the Cancel button, the default is "Cancel"
Bookmarks