I want to create a button that when clicked will enter todays date in the
selected cell. Basically a date stamp button. I tried doing a macro but it
did not work for me. I know the shortcut of ctrl+; to enter a date but I
have others using the worksheet.

Thanks

Create a button from the Forms command bar, and assign to it the
following macro:

Sub TimeStamp()
ActiveCell.Value = Int(Now)
End Sub



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Tom Meacham" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I want to create a button that when clicked will enter todays
>date in the selected cell. Basically a date stamp button. I
>tried doing a macro but it did not work for me. I know the
>shortcut of ctrl+; to enter a date but I have others using the
>worksheet.
>
> Thanks
>

or just
ActiveCell.Value = Date
<vbg>

Chip Pearson wrote:
>
> Create a button from the Forms command bar, and assign to it the
> following macro:
>
> Sub TimeStamp()
> ActiveCell.Value = Int(Now)
> End Sub
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
> "Tom Meacham" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> >I want to create a button that when clicked will enter todays
> >date in the selected cell. Basically a date stamp button. I
> >tried doing a macro but it did not work for me. I know the
> >shortcut of ctrl+; to enter a date but I have others using the
> >worksheet.
> >
> > Thanks
> >

--

Dave Peterson

Or if you wanted to put the date in several cells......<G>

Selection.Value = Date

Vaya con Dios,
Chuck, CABGx3


"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> or just
> ActiveCell.Value = Date
> <vbg>
>
> Chip Pearson wrote:
> >
> > Create a button from the Forms command bar, and assign to it the
> > following macro:
> >
> > Sub TimeStamp()
> > ActiveCell.Value = Int(Now)
> > End Sub
> >
> > --
> > Cordially,
> > Chip Pearson
> > Microsoft MVP - Excel
> > Pearson Software Consulting, LLC
> > www.cpearson.com
> >
> > "Tom Meacham" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > >I want to create a button that when clicked will enter todays
> > >date in the selected cell. Basically a date stamp button. I
> > >tried doing a macro but it did not work for me. I know the
> > >shortcut of ctrl+; to enter a date but I have others using the
> > >worksheet.
> > >
> > > Thanks
> > >
>
> --
>
> Dave Peterson