VBA Help with Button

[Dishboy09]

I am looking for some help with a VBA button in an excel sheet. I am wanting to have a click box/button that says states if the form is completed. Then after i have clicked the completed button/box the current days date shows underneath it. There will be multiple pages in the excel sheet, and would like them to be able to show what date each form was completed on each page.

Thanks!

 

[Logit]

Option Explicit


Sub ShwDate()
    ActiveSheet.Range("A1").Value = Now
End Sub

Place a button on each sheet, attached to this macro.

You can edit the cell range to suit. You can also format the selected cell to display the date / time as preferred.

 

[Dishboy09]

Worked perfectly!

Thank You

 

[Logit]

.
You are welcome.