Auto fill text box after selecting a value in a CombiBox

Hi all

I want to populate 6 text boxes with names depending on what is selected in a Combi box. So i want to select a name from my combi box "CBO_Teamleader" = Dave then i want this to populate 6 other boxes

Txt_OP1 = Bob
Txt_OP2 = Kevin
Txt_OP3 = Kenny
Txt_QC1 = Kevin
Txt_QC2 = Peter
Txt_QC3 = Theresa

I know i need to put it in the CBO_Teamleader change SUB and so far have the following that dosn't work

Please Login or Register  to view this content.

I have 4 names to chose from in CB_Teamleader and each one will need to populate the same 6 Txtboxes. I am not sure if its easier to pull the names for the 6 Txt boxes from my list on sheet 3 named ("Lists") the names are located in the following cells:

Txt_OP1 = Bob Lists N5
Txt_OP2 = Kevin Lists O5
Txt_OP3 = Kenny Lists P5
Txt_QC1 = Kevin Lists N11
Txt_QC2 = Peter Lists O11
Txt_QC3 = Theresa Lists P11

I get a compile error, method or data member not found. and it highlights the private sub line and the .value = "Bob"

Please Login or Register  to view this content.

I have copied and pasted them directly.

Oh dear thank you a little embarrassing, can i ask as i have 4 diffrent names in the teamleader box what is the best way to code the 6 txt boxes? is it to write an IF statement for each as i have done for Dave?

Sorry i changed the 6 combi boxes to text ones. The names are listed on the Lists page of the WB in cells D3-D6

Originally Posted by Norie

Isn't it the team leaders in D3-D6?

They are the ones yes
Mark
Rob
John
Dave

yes sorry not with it tonight so:
Team leader
Rob (D3)

OP1 Peter Bridle (N3) OP2 Dave Everitt (O3) OP3 Jim Hilton (P3)
QC1 Simon Morris (N9) QC2 Chris Hein (O9) QC3 Nev Rapley (P9)

Team leader
Mark (D4)

OP1 Alan Head (N6) OP2 Mark Ford (O6) OP3 Norman Smith (P6)
QC1 Huw Lovesey (N12) QC2 Andrew Martian (O12) QC3 Ken Thompson (P12)

Team leader
John (D5)

OP1 Rob Marone (N4) OP2 Nick Ryder (O4) OP3 Roy Osborne (P4)
QC1 David Jenkins (N10) QC2 Deigo Valanotti (O10) QC3 Gwyn Samual (P10)

Team leader
Dave (D6)

OP1 Bob Dhilan (N5) OP2 Kevin Hobbs (O5) OP3 Kenny Brookman (P5)
QC1 Kevin Grimwade (N11) QC2 Peter Marshal (O11) QC3 Threasa Jordan(P11)