Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the following code running for a combobox
Me.ComboBox2.Clear Me.ComboBox2.ColumnCount = 2 If LCase(myCell.Value) Like LCase(myPfx) Then Me.ComboBox2.AddItem myCell.Offset(0, 3) Me.ComboBox2.List(Me.ComboBox2.ListCount - 1, 1) = myCell.row End If I don't know how to make the combo box show a third column. I want to show the value of myCell, the offset of myCell, and the row that they come from. Other than changing the ColumnCount=3 what line of code do I put into the IF statement to show the value in the order listed above? This is running in Excel2003. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
linking a form combo box... results from the combo box to another | Excel Discussion (Misc queries) | |||
combo reference on another combo box for picking address etc. | Excel Worksheet Functions | |||
Combo box values based on other combo box value | Excel Programming | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) |