Each afterupdate event only refers to one combobox, so

Private Sub ComboBox1_AfterUpdate()
MyMacro ComboBox1
End Sub

Sub MyMacro(CBox As MSForms.ComboBox)
MsgBox CBox.Name & " " & CBox.Value
End Sub


--
Regards,
Tom Ogilvy


" wrote:

I'm trying to call a function in the after update sub, and pass it the
name of the combobox, which has been updated. I'm just not sure how to
access this. Can anyone help?

Thanks