Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
putting in todays date
hello,
I am looking for coding that will allow me to put in todays date into a cell when a checkbox is checked. Any help would be appreciated. Thanks, Dan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
putting in todays date
Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then Range("A1").Value = Now() Else Range("A1").Value = "" End If End Sub - Manges -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
putting in todays date
What would i change "now()" to if i do not want the time?
-----Original Message----- Private Sub CheckBox1_Click() If CheckBox1.Value = True Then Range("A1").Value = Now() Else Range("A1").Value = "" End If End Sub - Mangesh --- Message posted from http://www.ExcelForum.com/ . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
putting in todays date
Date
Range("A1").Value = Date -- Regards, Tom Ogilvy "Dan" wrote in message ... What would i change "now()" to if i do not want the time? -----Original Message----- Private Sub CheckBox1_Click() If CheckBox1.Value = True Then Range("A1").Value = Now() Else Range("A1").Value = "" End If End Sub - Mangesh --- Message posted from http://www.ExcelForum.com/ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
is there a formula that will subtract todays date from a hire date | Excel Worksheet Functions | |||
Making a date go red, if date passes todays date. | Excel Worksheet Functions | |||
Exel increment date problem wrt todays date. | Excel Worksheet Functions | |||
Create a button that will date stamp todays date in a cell | Excel Discussion (Misc queries) | |||
When I open my past invoice it keeps changing date to todays date | Excel Worksheet Functions |