Disregard case in VBA code. (UCase, LCase, Select Case)

[Orestees]

I'm working with some code I found online regarding passwords and logins within a userform. The issue I'm having is that the original code was specificly looking for uppercase inputs. There's only a few users that will be using the form, so I'd like to make this work with any case the user chooses. I just can't figure out how to remove it properly.

Please Login or Register  to view this content.

Any help is greatly appreciated.
Thanks in advance!

-Orestees

[Leith Ross]

Hello Orestees,

Change these 2 lines to make the user name and password case sensitive. Change the user names and passwords in the Select Case statement to what you want to use.

Please Login or Register  to view this content.

[Orestees]

I tried that before, but then I run into all sorts of problems. I've attached a demo file which should help. Thanks!

-OresteesPasswordDemo.xlsm

[MrShorty]

Some may not like this idea, but I've used the "Option Compare Text" statement (see VBA help for the option compare statement) to make all text comparisons case insensitive. Because it's a module level option, it will effect all procedures in your module, but, if you are certain you will never make a case-sensitive comparison, then this might be a workable option.

[Orestees]

That sounds like a very viable option for me MrShorty! How/where would this code work? Not familiar with it at all, sorry.

-Orestees

[Orestees]

Sorry, just re-read your post, I'll take a look in the help section. I'll let you know if I run into any issues. Be right back.

-Orestees

[JosephP]

you would put it at the top of the module but it is not needed here as your problem does not seem to exist-the original code converts all inputs to upper case before comparing them to upper case text, which makes the case the process case-insensitive

[Orestees]

I thought that was what it was supposed to do, but every time I test it using lowercase passwords (either in the input, code, or both) I get denied access. I must really be doing something wrong, lol.

-Orestees

[Orestees]

I tried using:

Please Login or Register  to view this content.

but to no avail.

-Orestees

[JosephP]

what name and password did you enter? can you post a workbook-no data necessary?

[BigBas]

I think Leith mentioned this, but changing the two lines of code with UCase should resolve.

Please Login or Register  to view this content.

You say you are running into problems. What problems are they?

[Orestees]

PasswordDemo.xlsm
The only username and password set right now is "ADMIN", "ADMIN".
I tried variations with uppercase and lowercase and didn't have an issue after adding in the Option Compare Text but when I tried adding in other usernames/passowrds, I ran into tons of issues.

Thanks for hanging in with me here gang.

-Orestees

[Leith Ross]

Hello Orestees ,

Here is a working example (case insensitive). If the inputs are converted to Upper Case then the strings in the Select Case must match.

Please Login or Register  to view this content.

[Orestees]

I also tried taking away the UCase on both in the most recent file but still had issues.

-Orestees

[JosephP]

as Leith said the UCase needs to be on both and then the strings you match to must be entered into the code in upper case.

[Orestees]

LEITH (or leith, lol) Thanks a ton. That worked no matter what combinations I used on it!
Thanks everyone for your help. I was driving myself crazy all day yesterday.

-Orestees

[Leith Ross]

Hello Orestees,

'S e do bheatha. Glad it is working.

[Orestees]

Go raibh míle maith agat Leith!

-Orestees (Proud videographer for the San Antonio Gaelic Athletic Club) http://en.wikipedia.org/wiki/San_Ant..._Athletic_Club