Calum

I think this is definitely do-able, but I'm unclear on how things are set
up.

It sounds like you need one form (or nested forms) for both scores and
competitors. Maybe even a multitab with competitor information on the first
tab and score comboboxes on the second tab. You can't easily "link" the
values of the comboboxes, but with a little code it should be OK. For
instance, if you have textbox with the competitor number, you could use the
value of that textbox to find it on the scores sheets and populate the
comboboxes with the scores.

Private Sub TextBox1_Change()

Dim FndComp as Range

If Len(Me.TextBox1.Text) 0 Then

Set FndComp = Sheets("Scores").Columns(1).Find(Me.TextBox1.Text)

If Not FndComp Is Nothing Then
Me.ComboBox1.Value = FndComp.Offset(0,1).Value
Me.ComboBox2.Value = FndComp.Offset(0,2).Value
Me.ComboBox3.Value = FndComp.Offset(0,3).Value
End If

End Sub

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.