- Jul 22, 2010
how do I get the name of the combo box that the user has clicked on? I mean, to get the reference for a button I have used ActiveSheet.Buttons(Application.Caller), but is there something like that I can use so when the subroutine is called for the change event on the combo box I can know which box is being changed? I ask because I have several different combo boxes I would like to have the same sub run for and I don't necessarily know the name of the box when it is clicked. Thanks in advance.