simple command button question

  • Thread starter Thread starter David
  • Start date Start date
D

David

I have placed a command button on sheet1 when clicked I need it to insert
todays date i.e. = today() into cell J2

Thanks in advance, David D
 
I have placed a command button on sheet1 when clicked I need it
to insert todays date i.e. = today() into cell J2
Click to expand...

Is it a Visual Basic CommandButton? If so, in Design Mode, use this Click
event code...

Private Sub CommandButton1_Click()
Range("J2").Value = Date
End Sub

Rick
 
Attach the button to the following macro

Sub myDate()
ActiveSheet.Cells(2,10).Value = Date
End Sub

(10 being the column number corresponding to "J")

Hope that helps. -Lisa



I have placed a command button on sheet1 when clicked I need it to insert
todays date i.e. = today() into cell J2

Thanks in advance, David D
Click to expand...

attach the
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Command Button Question 8
Code string for button 3
Access Automatically Send a notification email once a record is added 0
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Command button does not run code 2
Use A Command Button more than one time 1
Show Time Stamp in Cell when Command Button Clicked 1
How to copy one column values to another column based on conditionthat row2 contain todays date 4

Back
Top