see if string is in call caps

[luv2glyd]

I have the following to see if a string variable is in call caps:

Please Login or Register  to view this content.

is there a faster way vs. "If UCase(var1) = var1"?

[AlKey]

Here is a formula solution
In B1

Please Login or Register  to view this content.

v	A	B
1	APPLE	Entire word is in CAPS
2	Apple	Entire word is in not in caps
3	APPLe	Entire word is in not in caps
4	TABLE	Entire word is in CAPS

[jindon]

Not much but bit faster.

Please Login or Register  to view this content.

See also StrComp function with BinaryCompare.

[mikerickson]

How do you want to handle non-alphabetic characters

i.e. is "ABC123XYX" considered "all caps"?

[luv2glyd]

Not much but bit faster.

Please Login or Register  to view this content.

See also StrComp function with BinaryCompare.

What does $ do in UCase$?

[luv2glyd]

How do you want to handle non-alphabetic characters

i.e. is "ABC123XYX" considered "all caps"?

Did not realize that. Is it possible to exclude 1234... etc.

[jindon]

While you are in VBE;
go to [View] - [Object Browser]
enter ucase in search box

You will see many string functions and find few functions with $ at the end.
These functions returns explicitly String type data and bit faster.