running a macro on every refresh of the screen

S

shovit sahai

Hi,

I have a spreadsheet which is linked to live feeds from say Reuters. I
need to write a macro which auto-runs itself every time the spreadsheet
refreshes, or there is change in any of its cells. Something to the
effect "On every refresh, Do bla bla bla". Is there a way to implement
this in VB?

TIA

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 
J

Jake Marx

Hi shovit,

Yes - you can use the Worksheet_Change event subroutine to do this. To get
there, just right-click the worksheet's tab in Excel and select View Code.
Then, change the left dropdown above the code module to Worksheet, then
change the right dropdown to Change. Call your macro from that subroutine,
and each time any cell on the Worksheet changes, your macro will be
executed.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]
 
W

Wayne

Does this work when a cell is paste linked to another
excel file and that file changes, does that trigger the
on change event?

Wayne
-----Original Message-----
Hi shovit,

Yes - you can use the Worksheet_Change event subroutine to do this. To get
there, just right-click the worksheet's tab in Excel and select View Code.
Then, change the left dropdown above the code module to Worksheet, then
change the right dropdown to Change. Call your macro from that subroutine,
and each time any cell on the Worksheet changes, your macro will be
executed.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


shovit said:
Hi,

I have a spreadsheet which is linked to live feeds from say Reuters. I
need to write a macro which auto-runs itself every time the
spreadsheet refreshes, or there is change in any of its cells.
Something to the effect "On every refresh, Do bla bla bla". Is there
a way to implement this in VB?

TIA

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for
it!

.
 
J

Jake Marx

Hi Wayne,

Are you referring to DDE, web queries, or something else?

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]

Does this work when a cell is paste linked to another
excel file and that file changes, does that trigger the
on change event?

Wayne
-----Original Message-----
Hi shovit,

Yes - you can use the Worksheet_Change event subroutine to do this.
To get there, just right-click the worksheet's tab in Excel and
select View Code. Then, change the left dropdown above the code
module to Worksheet, then change the right dropdown to Change. Call
your macro from that subroutine, and each time any cell on the
Worksheet changes, your macro will be executed.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


shovit said:
Hi,

I have a spreadsheet which is linked to live feeds from say
Reuters. I need to write a macro which auto-runs itself every time
the spreadsheet refreshes, or there is change in any of its cells.
Something to the effect "On every refresh, Do bla bla bla". Is there
a way to implement this in VB?

TIA

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

.
 
W

Wayne

I did a paste all -> link from several other excel
spreadsheets. I notice when I update them the master
spreadsheet is updated with new values. I tried to
trigger the macro and the funny thing was it would
trigger when i updated one of the subsidiary spreadsheets
but not on the others, although the updates did happen.

Wayne
-----Original Message-----
Hi Wayne,

Are you referring to DDE, web queries, or something else?

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]

Does this work when a cell is paste linked to another
excel file and that file changes, does that trigger the
on change event?

Wayne
-----Original Message-----
Hi shovit,

Yes - you can use the Worksheet_Change event subroutine to do this.
To get there, just right-click the worksheet's tab in Excel and
select View Code. Then, change the left dropdown above the code
module to Worksheet, then change the right dropdown to Change. Call
your macro from that subroutine, and each time any cell on the
Worksheet changes, your macro will be executed.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


shovit sahai wrote:
Hi,

I have a spreadsheet which is linked to live feeds from say
Reuters. I need to write a macro which auto-runs itself every time
the spreadsheet refreshes, or there is change in any of its cells.
Something to the effect "On every refresh, Do bla bla bla". Is there
a way to implement this in VB?

TIA

*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

.
.
 
J

Jake Marx

Hi Wayne,

I think you're correct in that external links do not cause the
Worksheet_Change event to fire. But the Worksheet_Calculate event does
fire, so you may be able to use that.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]

I did a paste all -> link from several other excel
spreadsheets. I notice when I update them the master
spreadsheet is updated with new values. I tried to
trigger the macro and the funny thing was it would
trigger when i updated one of the subsidiary spreadsheets
but not on the others, although the updates did happen.

Wayne
-----Original Message-----
Hi Wayne,

Are you referring to DDE, web queries, or something else?

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]

Does this work when a cell is paste linked to another
excel file and that file changes, does that trigger the
on change event?

Wayne

-----Original Message-----
Hi shovit,

Yes - you can use the Worksheet_Change event subroutine to do this.
To get there, just right-click the worksheet's tab in Excel and
select View Code. Then, change the left dropdown above the code
module to Worksheet, then change the right dropdown to Change.
Call your macro from that subroutine, and each time any cell on the
Worksheet changes, your macro will be executed.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


shovit sahai wrote:
Hi,

I have a spreadsheet which is linked to live feeds from say
Reuters. I need to write a macro which auto-runs itself every time
the spreadsheet refreshes, or there is change in any of its cells.
Something to the effect "On every refresh, Do bla bla bla". Is
there a way to implement this in VB?

TIA

*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

.
.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top