Upper and lower case in VBA

[Mick S]

It seems that upper and lower case matters when working with VBA. Is there a way to make it where it doesn't matter? That way I wouldn't have to have so many potential options for my block if statements. See some of my partial code below.

Please Login or Register  to view this content.

[romperstomper]

You can use something like:

Please Login or Register  to view this content.

or:

Please Login or Register  to view this content.

or stick:

Please Login or Register  to view this content.

at the top of each module if you're lazy.

[Mick S]

ok cool. thanks.