Can you attach a sample workbook?
I have a User Form and I am trying to fill the controls using the columns of a Combobox. Combobox cbMake has 3 columns, bound column 1. I need the textbox to be equal to the value of the second column when the Combobox changes
I get the error:Code:Private Sub cbMake_Change() Me.txPerc.Value = Format(Me.cbMake.Column(1),"#0.0%") End Sub
'Could not get the column property'
'Invalid property array index'
Can anyone help me here please?
There are currently 1 users browsing this thread. (0 members and 1 guests)