Capitalization code Help - Muriuki

Hi any one with an Idea how to write code that capitalizes the first letter
of every word and one that capitalizes the whole statement. Very much
appreciated

Capitalization code Help - Danie

The StrConv function should be what you are looking for.  Look it up in the
help file for all the details.
--
Hope this helps,

Daniel P

Capitalization code Help - Steve

UCase() will convert a string to all upper case.

Alternatively you can use the StrConv() Function:

StrConv(MyString,vbUpperCase) 'convert to upper case
StrConv(MyString,vbProperCase) 'capitalize first character of each word

Steve