ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   automatic insert date when clicking cel (https://www.excelbanter.com/excel-programming/338867-automatic-insert-date-when-clicking-cel.html)

Steve wildemeersch

automatic insert date when clicking cel
 

Hi,
Does anybody know how to make that when clicking the cel, the date o
that day appears in the cel and stays there.

Thank

--
Steve wildemeersc
-----------------------------------------------------------------------
Steve wildemeersch's Profile: http://www.msusenet.com/member.php?userid=482
View this thread: http://www.msusenet.com/t-187102511


bill k

automatic insert date when clicking cel
 

select the cell and push <cntrl; for the date and <cntr<shift: fo
the time

you wouldn't really want, for this to happen each time you click onto
cell.

regards

Steve wildemeersch Wrote:
Hi,
Does anybody know how to make that when clicking the cel, the date of
that day appears in the cel and stays there.

Thanks


--
Steve wildemeersch
------------------------------------------------------------------------
Steve wildemeersch's Profile
http://www.msusenet.com/member.php?userid=4821
View this thread: http://www.msusenet.com/t-187102511


--
bill

-----------------------------------------------------------------------
bill k's Profile: http://www.excelforum.com/member.php...info&userid=82
View this thread: http://www.excelforum.com/showthread.php?threadid=40091


Steve wildemeersch[_2_]

automatic insert date when clicking cel
 

Thanks Bill,

thats easy enough...;-)

Regards

Stev

--
Steve wildemeersc
-----------------------------------------------------------------------
Steve wildemeersch's Profile: http://www.msusenet.com/member.php?userid=482
View this thread: http://www.msusenet.com/t-187102511



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com