View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Corey Corey is offline
external usenet poster
 
Posts: 172
Default Combobox to Show 2 values in same row

I can get 2 columns to display in a Combobox,
but i am unable to work out how to populate the other value from code.

Currently i use this:

Private Sub ComboBox2_DropButtonClick()
Application.ScreenUpdating = False
If ComboBox2.ListCount 0 Then Exit Sub
Dim LastCell As Long
Dim myrow As Long
On Error Resume Next
LastCell = Worksheets("to be Done").Cells(Rows.Count, "C").End(xlUp).Row
With ActiveWorkbook.Worksheets("to be Done")
..Select
For myrow = 1 To LastCell
If .Cells(myrow, 3) < "" Then
ComboBox2.AddItem Cells(myrow, 3)
End If
Next
End With
Application.ScreenUpdating = True
End Sub

But i want to add to the Combobox a Column to display the value in Column A as well as Column C in it.

How do i do this the above ?

Corey....