combobox selection to change cell range data

[ryan.fitzpatrick3]

This is probably very easy, I have a combobox that has 1-10, I would
like it where whatever I select in that combobox, lets say 5, the
range P528 gets populated with 5 all of the way down. Thanks.

 

[Nigel]

Private Sub ComboBox1_Change()
With ComboBox1
If .ListIndex > -1 Then
Range("P528") = .Value
End If
End With
End Sub