Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get…UCase or LCase ???
I don't want to convert; I have to check.
How to decide if a letter is LCase or UCase. I couldn't find any <get… expression. Thanks in advance Totmos |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get…UCase or LCase ???
If you want to check in excel then use
Exact worksheet function and if you want to use in vba use strcomp function make binary comparision StrComp(string1, string2[, compare]) strcomp([a1],[b1],vbbinarycompare) will return true if both string i lcase or ucase ..returns false if not in cas -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get…UCase or LCase ???
use exact function in worksheet to compare a case sensitive string.
in vba use strcomp and then use binary comparision -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ucase / macros | Excel Discussion (Misc queries) | |||
UCase in textbox, help | Excel Programming | |||
UCase Help | Excel Programming |