Hi. I have a combobox that needs to look up words that are not case sensitive. I use excel in a live environment where I have to look up records in a time sensitive manner. the problem I'm having is that if a word starts with a small f as in fRomAge (just made a word up there to demonstrate). Excel is changing it to Fromage or something as daft. I want CAT to be different from cat, CaT and CTa. and not to be changed whilst I'm typing. Has anybody got any clue how I can do this? There are multiple combo boxes on the same userform looking up a range for the input values and adding to the range if not found.