Combo box changing case of letters

[mmmreece]

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.

 

[Norie]

I'm sorry but I'm a bit confused.

You want the search to be case insensitive but you are worried about the case of what you are entering?

How are you searching?

 

[mmmreece]

I have a list of customers (for want of a better word). They use usernames that are unique to them. I get 20 to 30 seconds to get their record up. I type into the combobox and it autofills. for example, the username may be gdpc91 or iUchihA_HznO . Now if I try to type in iUchihA_HznO into the combo box the chance is that the i will turn into I in the lookup list. The lookup list is a range on a sheet. This means I have to type the name as best as I can and then go back and change any alterations that the autocomplete has made.

 

[Norie]

So you actually want things to be case sensitive?

 

[mmmreece]

If I type gdpc91 into the combo box I don't want it to automatically change to GDpc91 if there is another user in the list called GDpSmith if you see what I mean. I want it to not change the case that I type in

 

[Norie]

How about not using a combobox?

Use a textbox to enter the user, a listbox with the list of the names and code to filter the values, case sensitively, in the listbox.

 

[mmmreece]

I'll have a go at that tomorrow. Thanks. I'll let you know how it works out.