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
.
|