Caps lock

  • Thread starter Thread starter Paula Osheroff
  • Start date Start date
P

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!
 
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)
 
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
 
Back
Top