Assuming your combobox is in cell G2, in the worksheet code try something like:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$G$2" Then
Range("G5") = Target.Value 'do something with value
End If
End Sub
--
Les Torchia-Wells


"Todd in Dayton" wrote:

I have created a combo box by selecting a cell and using Data<Validation<List
and selecting values on a different worksheet.

I would like for when a user selects a value from the combobox, for a VBA
function to run (to change certain cell properties).

Is this possible???

Thank you very much.