Excell 2003 - VBA - Controlling Uppercase on Input

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Craig Brandt - 28 Apr 2008 23:02 GMT

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

Reply to this Message

Dave Peterson - 28 Apr 2008 23:17 GMT

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.

> Hi Guys:
>
[quoted text clipped - 10 lines]
> Thanks,
> Craig

Signature

Dave Peterson

Reply to this Message

Craig Brandt - 29 Apr 2008 14:43 GMT

This is exactly what I was looking for.

Thanks Dave.

> Don't bother the user:
>
[quoted text clipped - 16 lines]
> > Thanks,
> > Craig

Reply to this Message