Paula,

You can't input data into a messagebox!
If you mean an InputBox then allow the user to input in whichever case they
like
and turn their input to upper case in code.

MyString = InputBox ("Your input here")
MyString = StrConv(MyString , 1) 'convert to all upper case


HTH
Henry

"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!