How to have multiple passwords for a userform button

[chin67326]

Looking at the below site:

1.

http://www.mrexcel.com/forum/excel-q...nd-button.html

Please Login or Register  to view this content.

I want to know how can one have multiple password options for the button. For example, "bigdog" as well as "shoes" as well as "deskchair". I tried commas and Or but I get an error

Also:

2.

Looking at the below code:

Please Login or Register  to view this content.

How can one have more than one password? For example, "yoyo3" as well as "curtainthread" as well as "mountaintree"

Thanks!

[john55]

something similar

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[chin67326]

Thanks john55 but I tried it and got the below:

Run-time error '13':

Type mismatch

[john55]

perhaps

Please Login or Register  to view this content.

[chin67326]

This worked john55; THANKS!

[john55]

glad to be of help!

[HaHoBe]

Hi, chin67326,

code in ThisWorkbook:

Please Login or Register  to view this content.

Code behind UserForm1:

Please Login or Register  to view this content.

Ciao,
Holger

[chin67326]

Thanks Holger!