Automatic Cell population

[Ali]

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

 

[Frank Stone]

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.

 

[Guest]

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