PasswordChar Property 1

[Greycon]

Ok another I know enough to be dangerous question.

I have set up my password check input box.

But I can't figure out how to get the
PasswordChar Property to work.

Any possible help?

Dim Message, Title, Default, MyValue
Message = "Please Enter Your Password. Case Sensitive"
Title = "Security Check"
Default = "********"
MyValue = InputBox(Message, Title, Default)

Thank You,

Greycon

 

[TonyJollans]

Hi Greycon,

Yu can't do that with InputBox. You need to set up a simple Userform with a Textbox instead.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[Loomah]

Hi
I felt sure I'd seen something on this before where it's possible to change the 'type' of input box but I can't find it or work it out (in xl97) so I may be completely more stupid that first thought!

However, there is the following FAQ on the subject. All together more complicated than the solution I thought existed but....

faq707-4617

;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​

 

[Greycon]

Loonah,

Thank You very much!

I was looking just to add the PasswordChar Property,
but the API that they have does just what I wanted.

Kind of annoyed that I can't follow the code. But that's
what learning is all about. Beat your head against
something until it makes sense. right?

Thanks again,

Greycon