How to update a function when opening worksheet

[bugmenot]

I made

Please Login or Register  to view this content.

and then in a cell I entered =GetMonth()
and it displays what I want it to display but does not update when I reopen the program in the even that the date has changed... How would I go about doing this? I don't mind making a button to refresh the data as I already have one that does that and I could just add to it

[Leith Ross]

Hello bugmenot,

Make your Function Volatile. This will force it to update when the worksheet recalculates.

Volatile Method
Marks a user-defined function as volatile. A volatile function must be recalculated whenever calculation occurs in any cells on the worksheet. A nonvolatile function is recalculated only when the input variables change. This method has no effect if it's not inside a user-defined function used to calculate a worksheet cell.

Please Login or Register  to view this content.

[bugmenot]

Hmm, I have done that and when I go to reopen the workbook it has not changed.

The reason I am doing this (there might be a better way) is that I need the number of the month that corresponds to the current month.

In H2 I have =NOW() formatted as m
I then need to convert that to strictly a number, hense the function I created. I just can't get it to automatically update when I reopen the worksheet. (H2 automatically updates)

[Leith Ross]

Hello bugmenot,

You don't need to retrieve the cell value to return the month. You can do this way...

Please Login or Register  to view this content.

In cell "H2" use this formula...

Please Login or Register  to view this content.

[bugmenot]

Works! Thank you so much for your help. I really do appreciate it. You guys are very kind offering your help like this.