View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default Convert list to UPPER, lower & Proper cases.

My assumption is Cap first letter but what ending punctuation can be
expected, if any?


I'm pretty sure the macro ignores punctuation! It works on 'existing'
sentences that have mixed case content that doesn't display properly as
a sentence.


What to dim Start as?


Boolean if you like, but Variant is fine if you don't want to do the
extra typing.<g

Dim Start

or better yet...

Dim bStart

...since its datatype is Boolean in the context of this sub.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion