Continuous running macro
 

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.

Continuous running macro
 

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.

Continuous running macro
 

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.

Continuous running macro
 

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.

Continuous running macro
 

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.