Filling cells with multiple columns from ComboBox?

[Paulfakins]

I have a user form in which the user selects a part# from a 4 column combo box (part#, description, cost, labor) I have been able to put the CboBox.value and cboBox.listindex.value directly into worksheet cells. Is there a way to load the information from the other columns into the worksheet as well?

What I want is when the user chooses a part number the worksheet is automatically filled with all 4 columns of data. I have previously done this with the Index function on the worksheet, using the listindex.value to lookup the info in the parts database, but I would prefer to do it in VBA if possible

 

[Andrew Poulsom]

You can use the Column property like this (first column is 0):

Private Sub ComboBox1_Change()
    ActiveCell.Value = ComboBox1.Column(0, ComboBox1.ListIndex)
    ActiveCell.Offset(0, 1).Value = ComboBox1.Column(1, ComboBox1.ListIndex)
End Sub

 

[Paulfakins]

Thanks! I thought it would be fairly simple. I am fairly new at VBA and am still learning language conventions. I aprreciate the help.

 

[deepaksripaul]

You can use the Column property like this (first column is 0):

Private Sub ComboBox1_Change()
    ActiveCell.Value = ComboBox1.Column(0, ComboBox1.ListIndex)
    ActiveCell.Offset(0, 1).Value = ComboBox1.Column(1, ComboBox1.ListIndex)
End Sub

Hi Andrew,
Can i get the address of the particular range which i selected from combobox like A1, etc;
Please help me out.