Terima kasih Pak Nugroho,

Sangat membantu.

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



  Pak Sukarno,
  bisa lihat di attachement.
  mudah2an membantu


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



    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