Thread: How to test text case for Upper/Lower/Proper
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JS[_7_] JS[_7_] is offline
external usenet poster
  
Posts: 9
Default How to test text case for Upper/Lower/Proper
Hi All,
I'm trying to find a way to test case of certain text-strings to see if they
are upper, lower, proper, etc., in a VBA in Excel (similar to Word's VBA
Case functions (wdLowerCase, wdUpperCase, wdTitleSentence, wdTitleWord) - it
would be nice to have Excel functions: IsTextUpper, IsTextLower,
IsTextProper, etc.
Does anyone know how this may be done?
Thanks a lot - JS


Reply With QuoteReply With Quote