How does the month change? If by calculation, use the calculate event. If
by editing, then use the change event. In either case, call your macro.

--
Regards,
Tom Ogilvy

"John Baker" wrote in message
...
Thanks..that does work.

Now, is there any way to activate that macro when the contents of a fiield
changes. For
example, when the month changes in a field?

Regards

John

"Tom Ogilvy" wrote:

you are using but6 as a variable - and since it has not been set to a
value,
it is blank - should blank the caption of the button as well.


Sub test()
'
' test Macro
' Macro recorded 11/21/2003 by John H Baker
but6 = Format(Date, "yyyy_mm_dd")
Sheets("datefunction").Select
Range("f2").Select
ActiveCell() = but6
Sheets("Input").Select
Sheets("input").CommandButton6.Caption = but6
'
End Sub

worked fine for me.