[Resolved]Quick Question regarding Combo boxes & Listboxes

[whiteGSR]

I know from my VB6 days that when I am populating combo boxes (or listboxes), I could assign the ItemData property to store typically the ID number associated with the text selection.

In VBA, this ItemData is not available. How do I do this in VBA? I'm building this in excel if that makes a difference....

example:

For iCounter = 0 To UBound(arrProvinceState, 2)
            Me.cboProvState.AddItem arrProvinceState(1, iCounter)
            Me.cboProvState.ItemData(cboProvState.NewIndex) = arrProvinceState(0, iCounter)
        Next iCounter

I'd really appreciate any help regarding this.

Thanks in advance!

[DKenny]

Welcome to the Forums!

You can change the number of columns in the control to 2, storing the ID in Col1 and the text in Col2. Then make the first column invisible by changing the ColumnWidths property of the control.

In my post here , there is an example of adding data to a 2 column control.

[whiteGSR]

Welcome to the Forums!

You can change the number of columns in the control to 2, storing the ID in Col1 and the text in Col2. Then make the first column invisible by changing the ColumnWidths property of the control.

In my post here , there is an example of adding data to a 2 column control.

awesome, that worked flawlessly

thanks again!