| Title: | Microsoft Excel User Hints and Kinks |
| Moderator: | FIEVEL::FILGATE |
| Created: | Thu May 27 1993 |
| Last Modified: | Fri Jun 06 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 483 |
| Total number of notes: | 1391 |
I wrote some Excel (visual basic) functions that I am using to compute some of the cells
in my spreadsheet. The functions read the values of some cells and return a value.
I cannot figure out how to get the functions to be reinvoked when the values of the cells
that they use change. It would be ok if I could simply force the functions to be reinvoked
on demand. How can I do this?
I have tried to use the calc now and calc sheet in the calculation options, but these
buttons don't force the recalculation. I have also written a macro which does a
Worksheets(1).Calculate. This also failed to recalculate the cells.
I am using Excel 97.
---Karen
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 479.1 | MRPTH1::16.121.160.240::slab | [email protected] | Thu May 08 1997 22:58 | 4 | |
Help says to use SHIFT F9 to recalculate the current sheet. ALT SHIFT F9 does all active sheets. | |||||
| 479.2 | this doesn't recaculate my functions | TLE::MICHAELS | Karen Michaels | Fri May 09 1997 10:59 | 6 |
>Help says to use SHIFT F9 to recalculate the current sheet. > >ALT SHIFT F9 does all active sheets. This does recalculate my functions. I think this is the same as the recal functions in the calculation options tab, | |||||