Date update - a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a formula linked to a calendar. After selecting a date in the calendar which is linked to a cell, the formula, however, only works after you click on the formula bar and press enter.

How can I can this so it works automatically. Do I need an OnClick, Click, BeforeUpdate etc. macro; if so, what should it say?
 
... the formula, however, only works after you click on the formula bar
and press enter..

Jus a guess, cueing-in from the above line ..

Perhaps calculation mode has inadvertently been "switched",
without** your knowledge, to "Manual" ?
(this would explain what you observed)

Try pressing F9. Do the formulas now compute properly ?

---------
To change / check calc mode settings:
-------------------------------------
Click Tools > Options > Calculation tab
Check what's showing under "Calculation"
Click to set as desired > OK
(default / usual setting is "Automatic")

---
**The calculation mode of each Excel session
is dictated by the calc mode of the first book opened
within the session.

For example, if the first book's calculation mode is "Manual",
then the mode for all subsequent books opened in the same
Excel session (i.e. until / unless Excel is exited) will
be "Manual", irregardless of their earlier saved modes.

So, if you were to "unwittingly" open a 2nd book
(saved with calc mode "Auto")
in the above "Manual" session,
and then proceed to save this 2nd book in the same session,
the saved calc mode will now be "Manual"

--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <at>yahoo<dot>com
----
Les said:
I have a formula linked to a calendar. After selecting a date in the
Click to expand...
calendar which is linked to a cell, the formula, however, only works after
you click on the formula bar and press enter.
How can I can this so it works automatically. Do I need an OnClick,
Click to expand...
Click, BeforeUpdate etc. macro; if so, what should it say?
 
Thanks for your response.
Calculation, however, is set to Automatic ... and I have many times tried to recalculate using F9. I may try emailing the spreadsheet to you so you can have a try for yourself.
 
Sorry, Les. Nothing wrong with the formulas. Suggest
you put in a post in the excel.programming newsgroup
to ask about the calendar controls and code to
transfer values to target cells. Perhaps paste the
code you have in your book for the folks there to
check it out and help you to rectify.
--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <at>yahoo<dot>com
----
Les said:
Thanks for your response.
Calculation, however, is set to Automatic ... and I have many times tried
Click to expand...
to recalculate using F9. I may try emailing the spreadsheet to you so you
can have a try for yourself.
 
Back
Top