Paula,

The easiest way is to allow the user to enter the information in any case,
and then convert it to upper case. For example,

Dim S As String
S = InputBox("Enter Something")
S = UCase(S)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com


"Paula Osheroff" wrote in message
...
I need to make sure information entered in my message box
is in all caps. Is there a way to turn on the capslock in
VBA?

Thanks!