View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Stone Frank Stone is offline
external usenet poster
 
Posts: 134
Default Automatic Cell population

Hi. what is populating the combo box. you could use that
to create a recordset. or put the contents of the combo
box on a temp sheet. write another macro that loops
through the recordset or range, calling you first macro on
each loop. you may have to modify your first macro to get
it to reference the recordset or range. I have not tested
this. this is pure theory.
-----Original Message-----
Hi,

I have written a macro that does exactly what I need it

to
do except this: I need a macro that will use the entries
in a combo box to populate a cell and then run a macro
until all the possible selections have been selected.

Is this possible, and if so can anyone help me with the
code??

Thanks in advance,

Ali
.