[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!