I would like to create a macro that runs continuously while a
spreadsheet is open. I need to be able to enter information into the
spreadsheet, and have the sheet update itself as I enter data.

thanks for your help.

You have rethink your strategy because Excel cannot be in edit mode and have
a macro running; one or the other, not both.
Why do need a continuous macro ?

NickHK

"mcolson" wrote in message
oups.com...
I would like to create a macro that runs continuously while a
spreadsheet is open. I need to be able to enter information into the
spreadsheet, and have the sheet update itself as I enter data.

thanks for your help.

there isn't such a thing.
what is available are worksheet_change macros that will execute
immediately every time somebody makes a change on the worksheet.

links to sample threads about worksheet_change:

1.
http://groups.google.com/group/micro...ce7a07396bb968

2.
http://groups.google.com/group/micro...4931a8ec0547a1

hope this helps!
susan


On Mar 28, 7:40 am, "mcolson" wrote:
I would like to create a macro that runs continuously while a
spreadsheet is open. I need to be able to enter information into the
spreadsheet, and have the sheet update itself as I enter data.

thanks for your help.

You can't do that but you can have cells change in response to changes
elsewhere in the workbook. Please be specific about what you are trying to do.

Mike

"mcolson" wrote:

I would like to create a macro that runs continuously while a
spreadsheet is open. I need to be able to enter information into the
spreadsheet, and have the sheet update itself as I enter data.

thanks for your help.

Beyond the already suggested use of events,
Isn't that what formulas do?

The answer would depend on what you mean by Update and what that involves.

--
Regards,
Tom Ogilvy


"mcolson" wrote:

I would like to create a macro that runs continuously while a
spreadsheet is open. I need to be able to enter information into the
spreadsheet, and have the sheet update itself as I enter data.

thanks for your help.