Hot Fox: RE: ]] XL-mania [[ Mengisi Data Time,Date secara otomatis

domingo, 9 de outubro de 2011

RE: ]] XL-mania [[ Mengisi Data Time,Date secara otomatis

Saya coba bantu pakai macro sbb:

Private Sub Worksheet_Change(ByVal Target As Range)
'Jika yang berubah di kolom B
If Not Intersect(Target, Range("B:B")) Is Nothing Then
'jika kolom B tidak kosong, isikan tanggal dan jam
'di satu kolom sebelah kiri
If Not IsEmpty(Target) Then
With Target.Offset(0, -1)
.Value = Now()
.NumberFormat = "m/d/yyyy h:mm"
End With
Else
Target.Offset(0, -1) = vbNullString
End If
End If
End Sub

From: XL-mania@yahoogroups.com [mailto:XL-mania@yahoogroups.com] On Behalf
Of Pungki BERLIANTO
Sent: Saturday, October 08, 2011 11:27 AM
To: XL-mania@yahoogroups.com
Subject: ]] XL-mania [[ Mengisi Data Time,Date secara otomatis

Dear Para suhu EXEL Mania,

Saya ada pertanyaan tentang bagaimana cara mengisi data Time,Date (kolom A)
terakhir saat kita memasukkan data terakhir di kolom sebelahnya (Kolom B).
Lebih jelasnya saya sertakan pada attachment file.

Terima kasih atas Pertolongan

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (3)

Recent Activity:

New Members 54

Visit Your Group

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| ayooo... coba cari XL-mania di linkedin.com                       |
| tanggal 3-4 oktober yahoogroup akan mengalami maintenance.        |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message, melecehkan, tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan winzip jika perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni di : http://www.friendster.com/xlmania atau... |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html           |
+-------------------------------------------------------------------+
| Message lama ada di :                                             |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id] |
| http://www.mail-archive.com/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.