I am fairly new to VBA, so I am sure this is a fairly simple task.

I have inserted an activeX Listbox onto a sheet and want to use a single selection in the Listbox to populate a range for two rows of cells on another sheet. One row of populated cell data will remain constant regardless of the Listbox selection while the other row will change depending on the selection.

Below is what I have so far. I have the constant data row figured out, but I do not know how to code for the second row to change based on the ListBox selection. I know the listbox can put out numbers for each selection, but I am not sure how to make the output numbers correspond to different rows of data. The output range C2:AK2 would be different for each selection such as C2:AK2 for selection 1, C3:AK3 for selection 2, C4:AK4 for selection 3, etc.

Private Sub ListBox_Click()

With ListBox
Worksheets("Sheet1").Range("E10:AM10").ClearContents
Worksheets("Sheet1").Range("E11:AM11").ClearContents
Worksheets("Sheet1").Range("E10:AM10").Value = Worksheets("Sheet2").Range("C1:AK1").Value
Worksheets("Sheet1").Range("E11:AM11").Value = Worksheets("Sheet2").Range("C2:AK2").Value ---This line is what I need changed to populate different data based on the listbox selection.

End With

End Sub