I know in Word you can highlight and go to format--> fonts and choose for the letters to be all CAPS. Only when I highlight in excel and go to format and font... there is not a check box to make all the letters caps. Is there another way to do this? Thanks!

Try =UPPER(Range)

There is also a Text Converter function that Ivan F. Moala wrote that I'm attaching.

Hope that helps,

Smitty

Textbox1= StrConv(Textbox1, vbProperCase) Capitalize first Letter Of Word
Textbox1= StrConv(Textbox1, vbLowerCase) Lower Case Whole Word
Textbox1= StrConv(Textbox1, vbUpperCase) Capitalize Whole Word