I think I am missing something, you want to populate the combobox with the
values in a range or the other way round...?

My earlier post gave a solution where the combo-box value goes to an excel
cell, for the reverse, you need to do the following:

Private Sub UserForm_Initialize()

ComboBox1.RowSource = "Sheet1!A1:A10"

End Sub

or simply go to the properties and enter
Sheet1!A1:A10
in the rowsource property

Mangesh



"Rob" wrote in message
...
Thanks for the reply, the answer was similar to what was applied to the
VBA,
& was modified acordingly (mainly it was abreviated) but the list box in
the
form will not display the range value. It appears I've missed something, I
have tried both options, Data validation & range value either doesn't
work.
To be honest as this is a sub form and the range is only aprox. ten (was
only using this option for modification purpose so the form wouldn't need
to
be modified in the future only the worksheet). I may do it by check boxes
or
command button. Still it would be nice to get the list box going as a need
for it later will be applicable.



"Rob" wrote:

I am setting up a VB form inside an Excel workbook. I have put a Combo
box on
the form. My problem is linking the data for the combo box to a column
on the
work sheet.
Does any one have an easy to follow example please?