Globally declare all lower case inputs to Uppercase

[Trinidad3]

Hi

I once read an answer relating to my current question and i can't remember the solution or seem to find it on the net.
I have a module with many many functions. Inputs into spread sheet cells could be an M for Male or and F for female. If some one inputs a lower case f then my code doesnt recognise the answer. I know how to type MaleorFemale = Uppercase(MaleOrFemale) however i have so many functions now to go down and make many changes in all the functions will be tedious and i might forget one, or overlook one, and its not just MaleOrfemale but other variables too that could be inputted as lower case and i want to recognise them as uppercase.
Is there a way to globally declare all lower case inputs be recognised as upper case?

Thanks in advance.

Brian P

[MarvinP]

UCase them? http://techonthenet.com/excel/formulas/ucase.php

[Trinidad3]

Hi all, me again.

I just found the answer in a forum in a question posted by Sarah some time back.

the answer is to put
Option Compare Text
at the top of the module


thanks

BP

[Trinidad3]

Thanks Marvin.

Thats a help too.

Cheers
BP

[MarvinP]

Here is what your really want.
http://msdn.microsoft.com/en-us/libr...5f(VS.80).aspx

I was 2 minutes late with the answer. Glad to learn it myself.