Thanks for this information both of you - I cant test either of them because
I am having trouble with something so simple - Cant get my combo box to
display the names. Could it have something to do with the fact that the
cells in the range contain a formula?

Private Sub VisitList_Change()

Dim CustomerName As Range
Dim ws As Worksheet
Set ws = Worksheet("Lookuplists")
For Each VisitList In ws.Range("CustomerName")
With Me.VisitList
.AddItem CustomerName.Value
.List(.ListCount - 1, 1) = CustomerName.Offset(0, 1).Value
End With
Next VisitList
End Sub

"Leanne" wrote:

Hi,
I have been to http://www.contextures.on.ca/xlUserForm01.html#SetUp and
gained a lot of usefull information however the question I have does not seem
to be addressed there.

I want to create a form where the user selects an option from a combo box
and then enters the information relevant into the text box. This I have done
but what I do not know is how to get it to update the sheet in the correct
manner.

If someone selects Marchwood from the combo box and enters 01/05/08 in the
text box I want the record for Marchwood to be updated. Marchwood is in A2
and the data would need to update in C2 everytime Marchwood is chosen - and
the same for all the other companies.

Can anyone offer any suggestions?

Thanks