MsgBox with a password option?!!

[avworx]

Could it be possible to have a msg box that will have an option to input a password for the code to procede to the next action?
say for example I have a combobox with options A, B, and C. Option A and B could be selected without password, but option C could be selected only by ppl who knows the password otherwise the combobox stays at the option A or B.
Ideally I would like following flow of events:


by default option A or B is selected in a form, then
1. User attempts to select option C, msgbox shows up and has option to entry the password or cancel button to proceed further.
2. User enters the password, and if it is correct combobox changes it status to C, other wise status remain with previous options A or B.

Thanks.

[pbaldy]

Not that I know of with a message box, but you could use InputBox() or a solution like this to let the user enter a password:

http://www.baldyweb.com/WrappedForm.htm

[avworx]

thanks for the reply, yep input box worked out perfect. Now I have a code question.
how would I refer to the value inputed in the input box?
say for example:
inputbox ("please enter the password!!!")
if inputbox.value = "abc" then ... ( I know that this code wont work, but it gives u an idea of what i want to refer to)
else
msgbox ("input correct password!!!")
end if

[pbaldy]

Either of two methods. Set a variable:

VariableName = InputBox(...)
If VariableName = "Whatever" Then

or use it directly:

If InputBox(...) = "Whatever" Then

[avworx]

@ pbaldy, thank you a lot yr advice helped a lot. Now I need to find a solution so users cant type anything into combobox

[pbaldy]

Happy to help. If you set the Limit to List property of the combo to Yes, users will only be able to select from existing options.

[avworx]

yep, did that already. Thanks a lot!!! how difficult it would be to make the characters in the inputbox appear as dots or stars?

[pbaldy]

Personally I would use the method in my link, but I've also heard about this:

http://www.tek-tips.com/faqs.cfm?fid=4617

[avworx]

alright, thanks, I'll work on the hiding the password later. Thanks again!!!!