Edit Event from Macro
 

Currently have a simple open event, which auto populates some date ranges:

Sub Workbook_Open()
Range("E9").Value = (Date - 90)
Range("I9").Value = (Date + 14)
End Sub

Would like to give the user an opportunity to change the default values of
90 and 14; and save the update values. Preventing them from having to adjust
these everytime.

I intend to activate the macro by the use of a button. I just can't figure
out how to the the values from the input box into the workbook_open procedure.

Any help would be appreciated, and while I am at it, thanks to all who
participate in this forum. I have learned quite a bit from browsing thru
some of these threads.

Edit Event from Macro
 

Why not get them to save those values directly to cells and then use

Sub Workbook_Open()
Range("E9").Value = Date - Range("M1").Value
Range("I9").Value = Date + Range("M2").Value
End Sub

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Kervin Manasseh" wrote in
message ...
Currently have a simple open event, which auto populates some date ranges:

Sub Workbook_Open()
Range("E9").Value = (Date - 90)
Range("I9").Value = (Date + 14)
End Sub

Would like to give the user an opportunity to change the default values of
90 and 14; and save the update values. Preventing them from having to
adjust
these everytime.

I intend to activate the macro by the use of a button. I just can't
figure
out how to the the values from the input box into the workbook_open
procedure.

Any help would be appreciated, and while I am at it, thanks to all who
participate in this forum. I have learned quite a bit from browsing thru
some of these threads.