adding comboBox item in code

[hirenJ]

Hi all -- I have a combo Box that is based on a value list --i.e. its static -- how can I add another row to this comboBox at run-time in code?

NB: The comboBox contains two columns...

is this possible at runtime?


cheers

Hiren

)

 

[jebry]

Hi!

Just add the information using the rowsource like this:

Yourcombobox.RowSource = Yourcombobox.RowSource & ";" & FirstColumnInfo & ";" & SecondColumnInfo

hth
Jeff Bridgham
bridgham@purdue.edu

 

[matrixtech]

I believe you could also do cboCombo.AddItem (Parameters). This way you wouldnt have to resize columns and add the same things back into the list

 

[jebry]

Hi!

VBA doesn't support the AddItem method, that is only in VB. Otherwise I would agree 100%

Jeff Bridgham
bridgham@purdue.edu