Additional Properties for InputBox (PasswordChar)

[Guest]

It would be useful if additional properties for the InputBox function were
available. In this instance, I was particularly thinking of an equivalent to
the TextBox PasswordChar property.

I've found a workaround on this forum ( see
http://www.microsoft.com/office/com...&p=1&tid=509240b4-e10a-4a6c-ad51-8cf857ee2cfa
if you're looking for it!), but for most occasions, although this would be
very useful, it's not worth the sheer volume of additional code (c150 lines)
required to make it available to an InputBox, and a TextBox is not always
suitable for fairly basic workbooks.

If anyone else is aware of any workarounds to this which aren't as much of a
long way around as the details on Mr Klann's example referenced above, I'd be
very grateful!

Cheers
DS

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...1cb525e&dg=microsoft.public.excel.programming

 

[Duncan]

DS,

I had a look at the example, its not actually that hard to implement,
basically ignore the downloads, copy the code shown into a module, and
then call an input box by "InputBoxPwd" instead of InputBox"

Having searched myself for something like this and not found anything
im gratefull for you showing me the link!

Many thanks

Duncan

 

[Guest]

Duncan - you're a star. To be honest, I downloaded the examples, looked, saw
150+ lines of code to perform the function, winced, and kinda left it at
that.....!

Your suggestion makes perfect sense, cheers!
DS