VBA: converting text to uppercase

[blakemckenna]

I know how to convert text to uppercase in the Keypress event in VB but how do you do it using VBA?

Thanks,

Blake

[sciguyryan]

Exactly the same way if VBA has a KeyPress event that is.... UCase$() works in VBA I think atleast.

Cheers,

RyanJ

[blakemckenna]

VBA does have the Ucase() function, however, in VB I use the following statement in the KeyPress Event.

Text1.Text = Ucase(Asc(Chr(Keyascii)))

By using this statement, everytime you time a letter...it is converted to uppercase regardless if the CAPS Lock is on or not.

Unfortunately, I can't get this to work in VBA.

[sciguyryan]

VBA does have the Ucase() function, however, in VB I use the following statement in the KeyPress Event.

Text1.Text = Ucase(Asc(Chr(Keyascii)))

By using this statement, everytime you time a letter...it is converted to uppercase regardless if the CAPS Lock is on or not.

Unfortunately, I can't get this to work in VBA.

Well, I'm not shure if VBA has a KeyPress event - and if It does I have no idea what it would be.

Have you tried the MSDN VBA reference?

Cheers,

RyanJ

[blakemckenna]

I stand corrected.....you can use the same statement in VBA as in VB.

[sciguyryan]

I stand corrected.....you can use the same statement in VBA as in VB.

Well, thats going to save some searching time

And unless you want to return a variant string, use this:

Ucase$(Asc(Chr$(Keyascii)))

And I have one more question..... This:

Asc(Chr$(Keyascii))

Is the same as just having this...

Keyascii

Cheers,

RyanJ