Retreive 2nd column from combo box selected value

Trying to check the 2nd column value of a combo box SELECTED value. I can't figure this out.
Returns 2nd column of 1st value.

If Me.cHeadacheRack.Column(1,0) = "XYZ" Then
msgbox(Me.cHeadacheRack.Column(1,0))
End If

I can get the first value in the combo, but how do I get the selected value?

It's a bit difficult to help you without specifics.

But assuming you have Combobox1 property set as following...

BoundColumn = 1
ColumnCount = 2

Something like below to access Column 2's value.

Please Login or Register  to view this content.

Yes, bound =1 and column count =2. I copied your code and changed the combo box name to match my form. I get the same error.

This function triggers off the change of the combo box. It reads the second column and will return a value depending on the 2nd column.

Attachment 633649

Please Login or Register  to view this content.

What is the exact error code? And which line produces it?

See attached sample.

Edit: Where is your function stored? Is it in UserForm module?
Also, my code was just showing how to access column 2 value and did not use any error handling.
Note that when there is no value selected or invalid value typed for combobox1, you'll need to perform error handling.
As column 2 value is only accessible when valid value is selected for the combobox.

EDIT2: Please use code tag (# button) to post your code(s).

You are welcome