use CTRL key inside a macro IE CTRL + ;

  • Thread starter Thread starter Date Less
  • Start date Start date
D

Date Less

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.
 
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
 
Back
Top