Thank You and How can I extend my values in ComboBox entry????

[bralew]

Morning All,

Firstly, can I say thank you too all who have helped me and assisted me through my VBA baptism by fire.
In particular, Richard Buttery and Xlnitwit, who I feel have showed immense tolerance towards me. Thank you All.


One little question. I have the code below and on the second "If" argument I would like to insert
"A", "R", "X", "GG", "HH" rather than just "A"

I'm Ok with case insertion but not sure how to insert with an "If" command.
Can anyone Help? Much appreciated

Please Login or Register  to view this content.

[xlnitwit]

Do you mean this

Please Login or Register  to view this content.

[bralew]

Wonderful, Thank you very much. This should keep me busy for a while. :-)