Terima kasih Pak Nugroho,

Sekarang, maunya : time muncul di cell yang ditaruh pointer.

kalau pointer di A1 maka time di A1
kalau pointer di A2 maka time di A2

sukarno

  ----- Original Message ----- 
  From: Nugroho, Djoko 
  To: [email protected] 
  Sent: Friday, April 25, 2008 2:46 PM
  Subject: RE: [belajar-excel] Tombol Tanggal otomatis



  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 
      To: [email protected] 
      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 
        To: [email protected] 
        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"; 




   

Kirim email ke