I am new to VBA combo boxes so please be gentle!
I want a combo box that presents four columns of info per row (A, C,D & E) and then the value in Column A is retained for use in other macros.
From other posts I have got my combo box (cboProj) set up with a list filling routine in the from_initialize event.
Along the lines of :
but this only shows two columns of info - whats the trick?
I want a combo box that presents four columns of info per row (A, C,D & E) and then the value in Column A is retained for use in other macros.
From other posts I have got my combo box (cboProj) set up with a list filling routine in the from_initialize event.
Along the lines of :
Code:
Dim cProj as Range
Dim ws as Worksheet
Set ws = Worksheets ("WorksheetName1")
For each cProj in ws.Range("LookupRangeName")
With me.cboProj
.AddItem cProj.Value
.List(.ListCount-1,1)=cProj.Offset(0,1).Value
End With
Next cProj
Me.cbo.Proj.SetFocus
but this only shows two columns of info - whats the trick?