I have a user form that I have added 5 columns. When I select one of
the rows it fills in the combobox with the left most data and the rest
is blank. i woudl like the combobox to show all 5 columns.

I am also having trouble reading the value of this box to be used
later on. here is the code that I have and it cycles through each box
and returns boxcount of 0 and box.value returns an error. Thsi was
not happening when I only had one column and was using concatenate to
make columns. This just does nto look as professional.

For Each ctl In Me.Controls 'Check to see if the Comboboxes have
info
If TypeOf ctl Is msforms.ComboBox Then
MsgBox ctl.Name
If ctl.Value < "" Then
BoxCount = BoxCount + 1
Set Box = ctl 'The name of Combobox that is used
End If
End If
Next ctl

Thanks,
Jay