| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro Ctrl Key | Excel Discussion (Misc queries) | |||
| Anyone having Ctrl+C / Ctrl+V problems in E2007? | Excel Discussion (Misc queries) | |||
| How to forbid ctrl+c and ctrl+X in sheet? | Setting up and Configuration of Excel | |||
| CARET or ^, as in CTRL but CTRL !!! ??? | Excel Worksheet Functions | |||
| Esc Key Macro instead of Ctrl+... | Excel Discussion (Misc queries) | |||
Linear Mode
