You can adapt this approach to do it.

http://www.j-walk.com/ss/excel/tips/tip44.htm

--
Regards,
Tom Ogilvy



"cmpcwil2" wrote:


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?


--
cmpcwil2
------------------------------------------------------------------------
cmpcwil2's Profile: http://www.excelforum.com/member.php...o&userid=33411
View this thread: http://www.excelforum.com/showthread...hreadid=538838