ComboBox question
 

I'm new to programming in Excel/VBA so please bear with me.

I've taken over code from another developer. It has a sheet that has
combobox of email addresses. I looked at the properties and i
evidently is pulling the addresses from another sheet. The problem fo
me is that the sheet doesnt have an object, only code. The "cells" mus
be getting populated dynamically but I've looked thru "every" object i
the spreadsheet and can't find where the listFillRange is gettin
populated.

Does anyone know a) if the purpose of the Sheet (he called it Data
has no spreadsheet object and just code. Is it meant to be used as
workspace? b) where is it getting these email addresses from...the
are old and driving the users crazy.

Thanks for help in advance,

The Edge

PS...there is even another combobox on that page with listFillRang
pointing to itself but I still dont see where its getting data from.
Is this related to textbox.controlsource = cost_instr . Where do
look to find "cost_instr"

--
the_edge_2
-----------------------------------------------------------------------
the_edge_27's Profile: http://www.excelforum.com/member.php...fo&userid=2635
View this thread: http://www.excelforum.com/showthread.php?threadid=39622

ComboBox question
 

try looking in Insert=Names=Define

--
Regards,
Tom Ogilvy


"the_edge_27"
wrote in message
...

I'm new to programming in Excel/VBA so please bear with me.

I've taken over code from another developer. It has a sheet that has a
combobox of email addresses. I looked at the properties and it
evidently is pulling the addresses from another sheet. The problem for
me is that the sheet doesnt have an object, only code. The "cells" must
be getting populated dynamically but I've looked thru "every" object in
the spreadsheet and can't find where the listFillRange is getting
populated.

Does anyone know a) if the purpose of the Sheet (he called it Data)
has no spreadsheet object and just code. Is it meant to be used as a
workspace? b) where is it getting these email addresses from...they
are old and driving the users crazy.

Thanks for help in advance,

The Edge

PS...there is even another combobox on that page with listFillRange
pointing to itself but I still dont see where its getting data from.
Is this related to textbox.controlsource = cost_instr . Where do I
look to find "cost_instr"?


--
the_edge_27
------------------------------------------------------------------------
the_edge_27's Profile:
http://www.excelforum.com/member.php...o&userid=26357
View this thread: http://www.excelforum.com/showthread...hreadid=396221