ExcelBanter - use CTRL key inside a macro IE CTRL + ;

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - use CTRL key inside a macro IE CTRL + ; (https://www.excelbanter.com/excel-worksheet-functions/183719-use-ctrl-key-inside-macro-ie-ctrl-%3B.html)

Date Less

use CTRL key inside a macro IE CTRL + ;

I want to insert a static date into cell b2 based on what is in a2 [ =
if(a2="yes",today(),"nothing") The date changes when you open the program.
I want to use CTRL key inside a macro IE CTRL + ; to put in a static date.

FSt1

use CTRL key inside a macro IE CTRL + ;

hi
is the formula in b2?
this might work with out the control key.
If Range("A2") = "yes" Then
Range("B2") = Date
Else
Range("B2") = "Nothing"
End If

regards
FSt1

"Date Less" wrote:

I want to insert a static date into cell b2 based on what is in a2 [ =
if(a2="yes",today(),"nothing") The date changes when you open the program.
I want to use CTRL key inside a macro IE CTRL + ; to put in a static date.

All times are GMT +1. The time now is 12:05 AM.