Need timer event to change formula

Posted on 2013-09-13
Medium Priority
Last Modified: 2013-09-13
I need a timer process to run in seconds that will either mimic closing and opening a workbook without actually closing and reopening as this is currently the only way a formula updates from an add-in or do a loop to change the formula by deleteing the "=" and addit it back.  Formula would be =(a:1+b:2) for example.
Question by:leezac
LVL 25

Accepted Solution

Ejgil Hedegaard earned 2000 total points
ID: 39491396
User defined functions does not automatically recalculate with worksheet calculation.
Only if the input to the function change.

To make the function recalculate every time the worksheet calculates, insert Application.Volatile
as the first line in the function.

Author Closing Comment

ID: 39491414
Thank you - good information

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question