Caps lock

[Paula Osheroff]

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!

 

[Chip Pearson]

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)

 

[Henry]

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