Formating and updatingTextBoxes once an item has been selected in a ComboBox

[Raylou]

Good Day,

I hope someone can help me. I know very very little about vba.

As per my example, when I select a name in my ComboBox1, and the name exist in the list on sheet2, I want the Lid no. (TextBox2) be filled in with the appropriate number which match the name selected. Also if the name that exist is "Komiteelid" (as per the list) then the background colour of the Lid no. (TextBox2) must change to red and the text in the ComboBox1 must also change to red.

If the name does not exit in the list which is typed in, I would like the Lid.no (TextBox2) change to the background colour blue and the text "GAS" must appear in the TextBox and the name (text) in the ComboBox1 change to blue.

I thank you in advance!

Raymond

[LeoTaxi]

2 codes in combobox
1 activate by click, other by exit

Please Login or Register  to view this content.

Kind regards
Leo

[Raylou]

Hi Leo,

Thank you for your help. With a few tweaks I got it working exactly as I needed.

Thanks a million!

[LeoTaxi]

Hey Raylou,

maybe good for other users you let us know witch tweaks you did


Kind regards
Leo

[Raylou]

Hi Leo, sorry for the confusion. The code worked perfectly. The tweaks I was referring was just to change some of the preferences like adding something like the ComboBox having a forecolor of black and so. One again thank you for helping.

Have a great weekend.

Kind Regards,

Ray