Pak Sukarno,
Ini sy coba buatkan macro kecil... mudah2an cocok ...
 
 

-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of sukarno
Sent: Friday, April 25, 2008 2:37 PM
To: [email protected]
Subject: Re: [belajar-excel] Tombol Tanggal otomatis





Terima kasih pak Abdul, 
Kalau pake tombol gimana ya?
 
 
sukarno

----- Original Message ----- 
From: Abdul <mailto:[EMAIL PROTECTED]>  
To: belajar-excel@ <mailto:[email protected]> yahoogroups.com 
Sent: Friday, April 25, 2008 2:17 PM
Subject: Re: [belajar-excel] Tombol Tanggal otomatis




Dear Pak Karno,
 
Ctrl + Shift + :         Untuk membuat Jam
Ctrl + :                     Untuk membuat Tanggal
 
Salam
Abdul Hamid
 

----- Original Message ----- 
From: sukarno <mailto:[EMAIL PROTECTED]>  
To: belajar-excel@ <mailto:[email protected]> yahoogroups.com 
Sent: Friday, April 25, 2008 11:32 AM
Subject: [belajar-excel] Tombol Tanggal otomatis




Dear all,
 
Bagaimana cara membuat tanggal atau jam otomatis untuk suatu cell dengan 
menggukan tombol.
 
 
Misal : 
Pointer ada di A1
maka ketika saya pencet tombol tersebut, maka pada A1, tertulis tanggal atau 
jam sekarang.
 
Terima kasih
 
Sukarno





  _____  




Internal Virus Database is out-of-date.
Checked by AVG. 
Version: 7.5.520 / Virus Database: 0.0.0/0 - Release Date: <unknown> 12:00 AM



DISCLAIMER
---------------
"This email and any files transmitted with it are private and confidential and 
intended solely for the use of the individual or entity to which they are 
addressed. If you have received this email in error please notify the system 
manager. If you are not an intended recipient, you are hereby notified that any 
disclosure, copying, or distribution of this email, and/or taking any action 
based on its content, is strictly prohibited, and you should: (i) immediately 
delete this email and its attachments from your system, and (ii) inform the 
sender by reply email that you are not an intended recipient. Please note that 
any views or opinions presented in this email are solely those of the 
author/sender and do not necessarily represent those of ANJ Agri Group. ANJ 
Agri Group does not accept (i) any liability for its employee's communications 
that are against ANJ Agri's core values and/or outside the scope of employment 
and (ii) any damage caused by any virus transmitted by this email. Details can 
be found at: http://www.anjagri.com/disclaimer.htm"; 






 

Attachment: date_time.xls
Description: date_time.xls

Kirim email ke