Not differentiating between capital letters and lower case letters

[Eliot Y]

Hi,

I would like to know how I can make it so the equation on VBA doesn't differentiate between capitals letters and lower case. For the example below, I have had to put the conditions twice in order to include both capitals and lower case.

Please Login or Register  to view this content.

If Len(title) > length Then
title = Replace(title, "size", "")
title = Replace(title, "Size", "")
title = Replace(title, "height", "")
title = Replace(title, "Height", "")
End If

Please Login or Register  to view this content.

Many thanks in advance for any help.

[sktneer]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[Debraj Roy]

Hi Eliot..
Do you think, you able to search this thread, in your next visit.. HOW..

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[Eliot Y]

Thank you. I made a mistake with the original title, but I have now made then change. Please let me know if you have any guidance.

Thanks

[jindon]

Try

Please Login or Register  to view this content.

[Eliot Y]

Thank you Jindon. I have just tried your suggestion and it works - thanks a lot. But do you or anyone else know a way I can set it so that for all VBA equations there is no differentiation between capitals and lower case, so that i don't have to put it in for each one? Maybe there's a setting?

Thanks

[jindon]

Add one line at the top of the module

Please Login or Register  to view this content.

[Eliot Y]

Thank you. This seems to work.

[jindon]

If that takes care of your original question, select Thread Tools from the menu link above and mark this thread as SOLVED.