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
Bookmarks