Excell 2003 - VBA - Controlling Uppercase on Input

  • Thread starter Thread starter Craig Brandt
  • Start date Start date
C

Craig Brandt

Hi Guys:

I am using InputBox to permit input to a routine and would like to limit the
alpha-numeric input to use uppercase characters only.

This is the line I am using:

NewClient = InputBox("SNAM of New Client (AAA123)")

Is there a way to limit the alpha characters to uppercase only within the
inputBox line?

Thanks,
Craig
 
Don't bother the user:

NewClient = ucase(InputBox("SNAM of New Client (AAA123)"))

But there's no way to do this kind of masking using an inputbox.
 
Back
Top