Hi,
I have multiple VB toolbox comboBox's on a Excel spreadsheet, when a selection change occurs it makes a call to a webservice to populate adjacent cells with the returned data.

At the moment I have simply copied and pasted the code into each change event for each ComboBox, is there a way to have a single module that can detect which box made the change and then make the call?

A remember from doing some VB years ago that this was possible on forms using the index number I think, but not been able to replicate this on an Excel spreadsheet.

Can anyone help?