Getting the case (upper or lower) of a string character in V

[ScottNiag]

Hi. I am trying to learn VBA for Excel from a textbook at home. I have MOUS Excel expert. I am wasting huge amounts of time trying to find the answers to niggling liitle problems that seem to continually stuimp me.

I am currently doing an exercise where a user inputs a password. I store it as a string variable. The characters are all SUPPOSED to be upper case. You then have to check. There must be something which returns the CASE property of a character but I'll be darned if I can find it. Any ideas gratefully and lovingly accepted.

On a more general note, for those who have really conquered VBA - how did you learn it?
A class? Online course? Books? Just picked it up? I find that without an instructor to help out, the textbbok method is proving to be an exercise in continual frustration.

 

[zacemmel]

Just convert the string to upper case using ucase.

ucase("hi") would return "HI"

 

[ScottNiag]

No, that isn't quite it. I need to reject the password if any part of it wasn't entered as uppercase in the first place.

Ex. STUMpED

How to tell that one or more of the letters is lower case?

 

[Seti]

How about using the worksheet function CODE, it returns the code number for each character. If the value is between 65 (A) and 90 (Z), accept that letter, otherwise it is either lowercase or non-alpha, Or how about checking to see if UCASE(password)=password? You might need to loop through all characters though. The first solution allows you to exit before you check all characters once you find an invalid value.

 

[zacemmel]

How about doing something a lot easier?

If ucase(string)=string then...

 

[ScottNiag]

zace - it worked, thx. I actually tried about the same thing, where I stored Ucase(variable) as another variable2, then said if variable = variable2 then... but for some reason it didn't work that way. Thx again.

 

[VoG]

Surely you do not need to compare each letter:

If EnteredString = Pwd then

'your code

End if

 

[ScottNiag]

Vog

Actually the problem is more the setting up of a new pwd rather than comparing to an existing pwd. It's just an exercise in a textbook.