Macro

[one_more_cave_dweller]

Is it possible to have a macro create a sheet triggered by the date in a cell.
If so could it be triggered by the last day of the month instead of by a specific date.

Thanks ray:

 

[HalfAce]

I'm sure it's possible.
What is it exactly you want to do, and how is the date getting entered in the cell?

 

[one_more_cave_dweller]

The date that would trigger the macro is entered manually. From there I can write the macro to create the form, I just need to know how to get the date to trigger it.

Thanks

 

[HalfAce]

Maybe this...?

I'm using A10 as the cell to enter the date in and temporarily using A1 throughout the procedure. Change these to whatever you like.

In the worksheet module I have this:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim i As Long, x As Long
If Target.Address <> "$A$10" Then Exit Sub
[A1].Formula = "=EOMONTH(A10,0)" '(Any unused cell you like)
x = Target.Value
i = [A1].Value

If x = i Then
    Call Macro1
    [A1].ClearContents
Else: [A1].ClearContents
End If

End Sub

Hope it helps,
Dan