Hi,
I have a 25 combobox's on my spreadsheet, when an item from the list is
selected it makes a call to a webservice, which returns to items of
data. I want the returned data to be placed in the cells next to the
combobox that was used, i.e. combobox in cell B1 I want the data to go
in cell B2 and B3.
This works if I use the following in a for loop:

Cells(31, 3 + i) = ComponentResult(i)

But my problem is that the comboBox could be 1 of 25 therefore how do I
get the cell reference without hard coding 25 different possible cells?
Tired using the linked cell, also tried setting the active cell to that
of the combobox but with no joy! any ideas am I going about this in the
correct way?


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