Code to separate small from Capital letters

Hi,

would be grateful if someone could give me a hint on what code/function/procedure to use in order to compare a written name in a textbox (or similar) with a list of names in an excel sheet. In case the name in the text box matches a name in the excel list then the name in the list should be found. I do not want VBA to make difference to small or Capital letters (ie if marcus is written with small "m" or Capital "M" the program should not see it as 2 different entries.


Regards,


Marcus