Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
non case specific
my code reads:
if variable1 = "excluded" then call abc else call def end if my problem is 'variable1' is typed in by users and can be 'Excluded', 'EXCLUDED', and other combinations of caps and lower case letters. I want to include any and all combination of upper and lower case letters, as long as the spelling is correct. I am sure there is something I can wrap around 'variable1', but I don't know it. Thanks, Mike Allen |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
non case specific
Check this out:
http://www.excel-vba.com/v-functions.htm See the lcase section, should show you how. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
non case specific
There are options re case sensitivity set for the module via Option statements
at the top. The simplest solution to you current question is to use If LCase$(Variable1) = "excluded" Then On Fri, 21 Jan 2005 12:14:07 -0600, "mike allen" wrote: my code reads: if variable1 = "excluded" then call abc else call def end if my problem is 'variable1' is typed in by users and can be 'Excluded', 'EXCLUDED', and other combinations of caps and lower case letters. I want to include any and all combination of upper and lower case letters, as long as the spelling is correct. I am sure there is something I can wrap around 'variable1', but I don't know it. Thanks, Mike Allen |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
non case specific
As convention I always use Ucase but you could use lcase
if lcase(variable1) = "excluded" then Chips web link gives you a lot more info on this kind of thing though... You should take a look at it. HTH "mike allen" wrote: my code reads: if variable1 = "excluded" then call abc else call def end if my problem is 'variable1' is typed in by users and can be 'Excluded', 'EXCLUDED', and other combinations of caps and lower case letters. I want to include any and all combination of upper and lower case letters, as long as the spelling is correct. I am sure there is something I can wrap around 'variable1', but I don't know it. Thanks, Mike Allen |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
non case specific
if lcase(variable1) = "excluded" then
call abc else call def end if -- Regards, Tom Ogilvy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation from a list - Always case specific? | Excel Discussion (Misc queries) | |||
Searching for case specific data | Excel Discussion (Misc queries) | |||
Case specific LOOKUP alternative | Excel Discussion (Misc queries) | |||
Change the text from lower case to upper case in an Excel work boo | Excel Discussion (Misc queries) | |||
VBA- Calendar Control Click Event W Specific Select Case requirements | Excel Programming |