Automatic Cell population
 

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

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
.

Automatic Cell population
 

Hi,

I have a lookup in a cell that is changed by the selection
fromthe combo box, this is the cell I want to change using
a macro.

Thanks,
Ali
-----Original Message-----
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
.

.