Uppercase VBA code

[Michael Simpson]

Is there some way of setting a keyboard combination (say CTRL + U) so that any VBA code I've highlighted in the editor gets upper cased ?

 

[Tuelor]

I don't think that's possible - why do you want to upper case code?

 

[Michael Simpson]

Not so much the code, more text that I want to compare with specific strings. For that reason, I upper-case the "search for" string, so there's never a problem in comparing, say, "Hello" with "HEllo"

 

[Tuelor]

I think you would have to add UCase(string) each time.

 

[Michael Simpson]

Yes, but that won't work on the actual code in the VBA editor window, will it.

It's not unusual for an editor to allow you to set your own keyboard shortcuts, but if you can't do it in VBA, then you can't.

 

[Colin Legg]

If you use MZ-Tools which is an invaluable (and free) utility, there's an option to convert strings to upper case.

 

[Michael Simpson]

Thanks Colin - will check it out