Value From ComboBox On UserForm

[jlclyde]

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

 

[jlclyde]

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

I figured out the Ctl.value it is ctl.text <> "" then. I still ahve
no idea on how to show all of the information in my combobox window
after it has been selected. It only shows the first column.
Jay

 

[Dave Peterson]

Comboboxes only show one column's value when you select something.

Maybe it's time to use a listbox???

Or you could extract the values of all the columns and put them in textboxes
(seems a bit of overkill???).

 

[jlclyde]

Comboboxes only show one column's value when you select something.

Maybe it's time to use a listbox???

Or you could extract the values of all the columns and put them in textboxes
(seems a bit of overkill???).







--

Dave Peterson- Hide quoted text -

- Show quoted text -

The left is the most important. I think I will stick with the
Combobox. Thanks for the help.
Jay