Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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.... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
one column of cells show ####. Values show when I open it. Help | Excel Discussion (Misc queries) | |||
How does one show an intital value in the combobox | Excel Programming | |||
ComboBox to show a range | Excel Programming | |||
Show Filename Only in ComboBox Pulldown | Excel Discussion (Misc queries) | |||
Fill values into a listbox matching selected values from a combobox | Excel Programming |