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?