6 Messages
Digest #3614
Messages
Mon Oct 26, 2015 10:56 pm (PDT) . Posted by:
"Heri Pamungkas ( Gmail )" dchoosen88
السَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
Semangat pagi,.
Komputer Saya menggunakan Office 2010.
Dan hasilnya bisa Jalan Normal...
وَالسَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
Warm Regards,
On 27/10/2015 7:23, Samsudin samsudin@bayan.com.sg [belajar-excel] wrote:
>
> Pak Herri,
>
> Terima kasih infonya dan kalau boleh tahu bapak menggunakan Microsoft
> office berapa, sebagai informasi saya menggunakan computer perusahaan
> (semua program berlisensi resmi) dan munculnya seperti :
>
> Dim TampilkanWaktu
>
> Sub JamDigital()
>
> Set Sh = ThisWorkbook.Sheets(1)
>
> Sh.Calculate
>
> With Sh.Range("B5")
>
> .FormulaR1C1 = "=Now()"
>
> .NumberFormat = "hh:mm:ss AM/PM"
>
> End With
>
> TampilkanWaktu = Now + TimeValue("00:00:01")
>
> Application.OnTime TampilkanWaktu, "Jamdigital"
>
> End Sub
>
> Dan jika makro di run maka : Compile error: Variable not defined dan
> crusor mengarah keSh.
>
> *Terima kasih*
>
> **
>
> *Samsudin*
>
> *From:*belajar-excel@yahoogroups.com
> [mailto:belajar-excel@yahoogroups.com]
> *Sent:* Monday, October 26, 2015 9:24 PM
> *To:* belajar-excel@yahoogroups.com
> *Subject:* Re: [belajar-excel] membuat jam digital
>
>
>
> السَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
> Semangat pagi,.
>
> Alhamdulillah di komputer saya
> Script bapak berjalan lancar kok.
>
>
>
> وَالسَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
>
> Warm Regards,
>
> On 26/10/2015 16:30, Samsudin samsudin@bayan.com.sg
> <mailto:samsudin@bayan.com.sg> [belajar-excel] wrote:
>
> Dear Master Excel,
>
> Bagaimana caranya script untuk menampilkan jam digital pada excel
> bisa berfungsi, karena saya sudah mencobanya tetapi tidak
> berhasil, masalahnya dimana?
>
> Berikut script :
>
> Script :
>
> Dim TampilkanWaktu
>
> Sub JamDigital()
>
> Set Sh = ThisWorkbook.
>
> Sh.Calculate
>
>
> With Sh.Range("
>
> .FormulaR1C1 = "=Now()
>
> .NumberFormat = "hh:mm:
>
> End With
>
>
> TampilkanWaktu = Now + TimeValue("
>
> Application.
>
> End Sub
>
> *Terima kasih*
>
> *Samsudin*
>
> ------------
>
>
>
>
>
> This message (including any attachments) contains confidential information intended
>
> for a specific individual and purpose, and is protected by law. If you are not the
>
> intended recipient, you should delete this message and hereby notified that any
>
> disclosure, copying, or distribution of this message (or any part thereof), or the
>
> taking of any action based on it, is strictly prohibited. No liability or responsibility
>
> is accepted if information or data is, for whatever reason corrupted or does not reach
>
> its intended recipient. No warranty is given that this email is free of viruses. The
>
> views expressed in this email are, unless otherwise stated, those of the author and
>
> not those of the Company or its management. The Company reserves the right to monitor,
>
> intercept and block emails addressed to its users or take any other action in accordance
>
> with its email use policy.
>
> ------------
>
> This message (including any attachments) contains confidential information intended
> for a specific individual and purpose, and is protected by law. If you are not the
> intended recipient, you should delete this message and hereby notified that any
> disclosure, copying, or distribution of this message (or any part thereof), or the
> taking of any action based on it, is strictly prohibited. No liability or responsibility
> is accepted if information or data is, for whatever reason corrupted or does not reach
> its intended recipient. No warranty is given that this email is free of viruses. The
> views expressed in this email are, unless otherwise stated, those of the author and
> not those of the Company or its management. The Company reserves the right to monitor,
> intercept and block emails addressed to its users or take any other action in accordance
> with its email use policy.
>
>
Mon Oct 26, 2015 11:36 pm (PDT) . Posted by:
"Samsudin"
Pak Heri,
Terima kasih, benar saja di computer bapak bisa berjalan normal karena tidak ada script : Option Explicit.
Terima kasih
Samsudin
From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Tuesday, October 27, 2015 1:53 PM
To: belajar-excel@yahoogroups.com
Subject: Re: [belajar-excel] membuat jam digital [1 Attachment]
السَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
Semangat pagi,.
Komputer Saya menggunakan Office 2010.
Dan hasilnya bisa Jalan Normal...
[cid:image001.jpg@01D110BF.A4361220]
وَالسَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
Warm Regards,
On 27/10/2015 7:23, Samsudin samsudin@bayan.com.sg<mailto:samsudin@bayan.com.sg> [belajar-excel] wrote:
Pak Herri,
Terima kasih infonya dan kalau boleh tahu bapak menggunakan Microsoft office berapa, sebagai informasi saya menggunakan computer perusahaan (semua program berlisensi resmi) dan munculnya seperti :
Dim TampilkanWaktu
Sub JamDigital()
Set Sh = ThisWorkbook.Sheets(1)
Sh.Calculate
With Sh.Range("B5")
.FormulaR1C1 = "=Now()"
.NumberFormat = "hh:mm:ss AM/PM"
End With
TampilkanWaktu = Now + TimeValue("00:00:01")
Application.OnTime TampilkanWaktu, "Jamdigital"
End Sub
Dan jika makro di run maka : Compile error: Variable not defined dan crusor mengarah ke Sh.
Terima kasih
Samsudin
From: belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com> [mailto:belajar-excel@yahoogroups.com]
Sent: Monday, October 26, 2015 9:24 PM
To: belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>
Subject: Re: [belajar-excel] membuat jam digital
السَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
Semangat pagi,.
Alhamdulillah di komputer saya
Script bapak berjalan lancar kok.
وَالسَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
Warm Regards,
On 26/10/2015 16:30, Samsudin samsudin@bayan.com.sg<mailto:samsudin@bayan.com.sg> [belajar-excel] wrote:
[cid:image002.jpg@01D110BF.A4361220]
Dear Master Excel,
Bagaimana caranya script untuk menampilkan jam digital pada excel bisa berfungsi, karena saya sudah mencobanya tetapi tidak berhasil, masalahnya dimana?
Berikut script :
Script :
Dim TampilkanWaktu
Sub JamDigital()
Set Sh = ThisWorkbook.Sheets(1)
Sh.Calculate
With Sh.Range("B5")
.FormulaR1C1 = "=Now()"
.NumberFormat = "hh:mm:ss AM/PM"
End With
TampilkanWaktu = Now + TimeValue("00:00:01")
Application.OnTime TampilkanWaktu, "Jamdigital"
End Sub
Terima kasih
Samsudin
----------------------------------------------------------
This message (including any attachments) contains confidential information intended
for a specific individual and purpose, and is protected by law. If you are not the
intended recipient, you should delete this message and hereby notified that any
disclosure, copying, or distribution of this message (or any part thereof), or the
taking of any action based on it, is strictly prohibited. No liability or responsibility
is accepted if information or data is, for whatever reason corrupted or does not reach
its intended recipient. No warranty is given that this email is free of viruses. The
views expressed in this email are, unless otherwise stated, those of the author and
not those of the Company or its management. The Company reserves the right to monitor,
intercept and block emails addressed to its users or take any other action in accordance
with its email use policy.
----------------------------------------------------------
This message (including any attachments) contains confidential information intended
for a specific individual and purpose, and is protected by law. If you are not the
intended recipient, you should delete this message and hereby notified that any
disclosure, copying, or distribution of this message (or any part thereof), or the
taking of any action based on it, is strictly prohibited. No liability or responsibility
is accepted if information or data is, for whatever reason corrupted or does not reach
its intended recipient. No warranty is given that this email is free of viruses. The
views expressed in this email are, unless otherwise stated, those of the author and
not those of the Company or its management. The Company reserves the right to monitor,
intercept and block emails addressed to its users or take any other action in accordance
with its email use policy.
----------------------------------------------------------
This message (including any attachments) contains confidential information intended
for a specific individual and purpose, and is protected by law. If you are not the
intended recipient, you should delete this message and hereby notified that any
disclosure, copying, or distribution of this message (or any part thereof), or the
taking of any action based on it, is strictly prohibited. No liability or responsibility
is accepted if information or data is, for whatever reason corrupted or does not reach
its intended recipient. No warranty is given that this email is free of viruses. The
views expressed in this email are, unless otherwise stated, those of the author and
not those of the Company or its management. The Company reserves the right to monitor,
intercept and block emails addressed to its users or take any other action in accordance
with its email use policy.
Terima kasih, benar saja di computer bapak bisa berjalan normal karena tidak ada script : Option Explicit.
Terima kasih
Samsudin
From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Tuesday, October 27, 2015 1:53 PM
To: belajar-excel@yahoogroups.com
Subject: Re: [belajar-excel] membuat jam digital [1 Attachment]
السَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
Semangat pagi,.
Komputer Saya menggunakan Office 2010.
Dan hasilnya bisa Jalan Normal...
[cid:image001.jpg@01D110BF.A4361220]
وَالسَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
Warm Regards,
On 27/10/2015 7:23, Samsudin samsudin@bayan.com.sg<mailto:samsudin@bayan.com.sg> [belajar-excel] wrote:
Pak Herri,
Terima kasih infonya dan kalau boleh tahu bapak menggunakan Microsoft office berapa, sebagai informasi saya menggunakan computer perusahaan (semua program berlisensi resmi) dan munculnya seperti :
Dim TampilkanWaktu
Sub JamDigital()
Set Sh = ThisWorkbook.Sheets(1)
Sh.Calculate
With Sh.Range("B5")
.FormulaR1C1 = "=Now()"
.NumberFormat = "hh:mm:ss AM/PM"
End With
TampilkanWaktu = Now + TimeValue("00:00:01")
Application.OnTime TampilkanWaktu, "Jamdigital"
End Sub
Dan jika makro di run maka : Compile error: Variable not defined dan crusor mengarah ke Sh.
Terima kasih
Samsudin
From: belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com> [mailto:belajar-excel@yahoogroups.com]
Sent: Monday, October 26, 2015 9:24 PM
To: belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>
Subject: Re: [belajar-excel] membuat jam digital
السَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
Semangat pagi,.
Alhamdulillah di komputer saya
Script bapak berjalan lancar kok.
وَالسَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
Warm Regards,
On 26/10/2015 16:30, Samsudin samsudin@bayan.com.sg<mailto:samsudin@bayan.com.sg> [belajar-excel] wrote:
[cid:image002.jpg@01D110BF.A4361220]
Dear Master Excel,
Bagaimana caranya script untuk menampilkan jam digital pada excel bisa berfungsi, karena saya sudah mencobanya tetapi tidak berhasil, masalahnya dimana?
Berikut script :
Script :
Dim TampilkanWaktu
Sub JamDigital()
Set Sh = ThisWorkbook.
Sh.Calculate
With Sh.Range("
.FormulaR1C1 = "=Now()
.NumberFormat = "hh:mm:
End With
TampilkanWaktu = Now + TimeValue("
Application.
End Sub
Terima kasih
Samsudin
------------
This message (including any attachments) contains confidential information intended
for a specific individual and purpose, and is protected by law. If you are not the
intended recipient, you should delete this message and hereby notified that any
disclosure, copying, or distribution of this message (or any part thereof), or the
taking of any action based on it, is strictly prohibited. No liability or responsibility
is accepted if information or data is, for whatever reason corrupted or does not reach
its intended recipient. No warranty is given that this email is free of viruses. The
views expressed in this email are, unless otherwise stated, those of the author and
not those of the Company or its management. The Company reserves the right to monitor,
intercept and block emails addressed to its users or take any other action in accordance
with its email use policy.
------------
This message (including any attachments) contains confidential information intended
for a specific individual and purpose, and is protected by law. If you are not the
intended recipient, you should delete this message and hereby notified that any
disclosure, copying, or distribution of this message (or any part thereof), or the
taking of any action based on it, is strictly prohibited. No liability or responsibility
is accepted if information or data is, for whatever reason corrupted or does not reach
its intended recipient. No warranty is given that this email is free of viruses. The
views expressed in this email are, unless otherwise stated, those of the author and
not those of the Company or its management. The Company reserves the right to monitor,
intercept and block emails addressed to its users or take any other action in accordance
with its email use policy.
------------
This message (including any attachments) contains confidential information intended
for a specific individual and purpose, and is protected by law. If you are not the
intended recipient, you should delete this message and hereby notified that any
disclosure, copying, or distribution of this message (or any part thereof), or the
taking of any action based on it, is strictly prohibited. No liability or responsibility
is accepted if information or data is, for whatever reason corrupted or does not reach
its intended recipient. No warranty is given that this email is free of viruses. The
views expressed in this email are, unless otherwise stated, those of the author and
not those of the Company or its management. The Company reserves the right to monitor,
intercept and block emails addressed to its users or take any other action in accordance
with its email use policy.
Mon Oct 26, 2015 11:41 pm (PDT) . Posted by:
"Samsudin"
Pak Heri,
Berikut kendala lagi muncul sbb :
[cid:image001.png@01D110C4.83E06250]
Pada saat saya mau menyimpan file tersebut muncul peringatan seperti tersebut di atas, bagaimana menyelesaikan masalah ini, mohon bantuannya kepada master excel yang lainnya.
Terima kasih
Samsudin
From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Tuesday, October 27, 2015 1:53 PM
To: belajar-excel@yahoogroups.com
Subject: Re: [belajar-excel] membuat jam digital [1 Attachment]
السَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
Semangat pagi,.
Komputer Saya menggunakan Office 2010.
Dan hasilnya bisa Jalan Normal...
[cid:image002.jpg@01D110C4.83E06250]
وَالسَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
Warm Regards,
On 27/10/2015 7:23, Samsudin samsudin@bayan.com.sg<mailto:samsudin@bayan.com.sg> [belajar-excel] wrote:
Pak Herri,
Terima kasih infonya dan kalau boleh tahu bapak menggunakan Microsoft office berapa, sebagai informasi saya menggunakan computer perusahaan (semua program berlisensi resmi) dan munculnya seperti :
Dim TampilkanWaktu
Sub JamDigital()
Set Sh = ThisWorkbook.Sheets(1)
Sh.Calculate
With Sh.Range("B5")
.FormulaR1C1 = "=Now()"
.NumberFormat = "hh:mm:ss AM/PM"
End With
TampilkanWaktu = Now + TimeValue("00:00:01")
Application.OnTime TampilkanWaktu, "Jamdigital"
End Sub
Dan jika makro di run maka : Compile error: Variable not defined dan crusor mengarah ke Sh.
Terima kasih
Samsudin
From: belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com> [mailto:belajar-excel@yahoogroups.com]
Sent: Monday, October 26, 2015 9:24 PM
To: belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>
Subject: Re: [belajar-excel] membuat jam digital
السَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
Semangat pagi,.
Alhamdulillah di komputer saya
Script bapak berjalan lancar kok.
وَالسَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
Warm Regards,
On 26/10/2015 16:30, Samsudin samsudin@bayan.com.sg<mailto:samsudin@bayan.com.sg> [belajar-excel] wrote:
[cid:image003.jpg@01D110C4.83E06250]
Dear Master Excel,
Bagaimana caranya script untuk menampilkan jam digital pada excel bisa berfungsi, karena saya sudah mencobanya tetapi tidak berhasil, masalahnya dimana?
Berikut script :
Script :
Dim TampilkanWaktu
Sub JamDigital()
Set Sh = ThisWorkbook.Sheets(1)
Sh.Calculate
With Sh.Range("B5")
.FormulaR1C1 = "=Now()"
.NumberFormat = "hh:mm:ss AM/PM"
End With
TampilkanWaktu = Now + TimeValue("00:00:01")
Application.OnTime TampilkanWaktu, "Jamdigital"
End Sub
Terima kasih
Samsudin
----------------------------------------------------------
This message (including any attachments) contains confidential information intended
for a specific individual and purpose, and is protected by law. If you are not the
intended recipient, you should delete this message and hereby notified that any
disclosure, copying, or distribution of this message (or any part thereof), or the
taking of any action based on it, is strictly prohibited. No liability or responsibility
is accepted if information or data is, for whatever reason corrupted or does not reach
its intended recipient. No warranty is given that this email is free of viruses. The
views expressed in this email are, unless otherwise stated, those of the author and
not those of the Company or its management. The Company reserves the right to monitor,
intercept and block emails addressed to its users or take any other action in accordance
with its email use policy.
----------------------------------------------------------
This message (including any attachments) contains confidential information intended
for a specific individual and purpose, and is protected by law. If you are not the
intended recipient, you should delete this message and hereby notified that any
disclosure, copying, or distribution of this message (or any part thereof), or the
taking of any action based on it, is strictly prohibited. No liability or responsibility
is accepted if information or data is, for whatever reason corrupted or does not reach
its intended recipient. No warranty is given that this email is free of viruses. The
views expressed in this email are, unless otherwise stated, those of the author and
not those of the Company or its management. The Company reserves the right to monitor,
intercept and block emails addressed to its users or take any other action in accordance
with its email use policy.
----------------------------------------------------------
This message (including any attachments) contains confidential information intended
for a specific individual and purpose, and is protected by law. If you are not the
intended recipient, you should delete this message and hereby notified that any
disclosure, copying, or distribution of this message (or any part thereof), or the
taking of any action based on it, is strictly prohibited. No liability or responsibility
is accepted if information or data is, for whatever reason corrupted or does not reach
its intended recipient. No warranty is given that this email is free of viruses. The
views expressed in this email are, unless otherwise stated, those of the author and
not those of the Company or its management. The Company reserves the right to monitor,
intercept and block emails addressed to its users or take any other action in accordance
with its email use policy.
Berikut kendala lagi muncul sbb :
[cid:image001.png@01D110C4.83E06250]
Pada saat saya mau menyimpan file tersebut muncul peringatan seperti tersebut di atas, bagaimana menyelesaikan masalah ini, mohon bantuannya kepada master excel yang lainnya.
Terima kasih
Samsudin
From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Tuesday, October 27, 2015 1:53 PM
To: belajar-excel@yahoogroups.com
Subject: Re: [belajar-excel] membuat jam digital [1 Attachment]
السَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
Semangat pagi,.
Komputer Saya menggunakan Office 2010.
Dan hasilnya bisa Jalan Normal...
[cid:image002.jpg@01D110C4.83E06250]
وَالسَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
Warm Regards,
On 27/10/2015 7:23, Samsudin samsudin@bayan.com.sg<mailto:samsudin@bayan.com.sg> [belajar-excel] wrote:
Pak Herri,
Terima kasih infonya dan kalau boleh tahu bapak menggunakan Microsoft office berapa, sebagai informasi saya menggunakan computer perusahaan (semua program berlisensi resmi) dan munculnya seperti :
Dim TampilkanWaktu
Sub JamDigital()
Set Sh = ThisWorkbook.Sheets(1)
Sh.Calculate
With Sh.Range("B5")
.FormulaR1C1 = "=Now()"
.NumberFormat = "hh:mm:ss AM/PM"
End With
TampilkanWaktu = Now + TimeValue("00:00:01")
Application.OnTime TampilkanWaktu, "Jamdigital"
End Sub
Dan jika makro di run maka : Compile error: Variable not defined dan crusor mengarah ke Sh.
Terima kasih
Samsudin
From: belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com> [mailto:belajar-excel@yahoogroups.com]
Sent: Monday, October 26, 2015 9:24 PM
To: belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>
Subject: Re: [belajar-excel] membuat jam digital
السَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
Semangat pagi,.
Alhamdulillah di komputer saya
Script bapak berjalan lancar kok.
وَالسَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
Warm Regards,
On 26/10/2015 16:30, Samsudin samsudin@bayan.com.sg<mailto:samsudin@bayan.com.sg> [belajar-excel] wrote:
[cid:image003.jpg@01D110C4.83E06250]
Dear Master Excel,
Bagaimana caranya script untuk menampilkan jam digital pada excel bisa berfungsi, karena saya sudah mencobanya tetapi tidak berhasil, masalahnya dimana?
Berikut script :
Script :
Dim TampilkanWaktu
Sub JamDigital()
Set Sh = ThisWorkbook.
Sh.Calculate
With Sh.Range("
.FormulaR1C1 = "=Now()
.NumberFormat = "hh:mm:
End With
TampilkanWaktu = Now + TimeValue("
Application.
End Sub
Terima kasih
Samsudin
------------
This message (including any attachments) contains confidential information intended
for a specific individual and purpose, and is protected by law. If you are not the
intended recipient, you should delete this message and hereby notified that any
disclosure, copying, or distribution of this message (or any part thereof), or the
taking of any action based on it, is strictly prohibited. No liability or responsibility
is accepted if information or data is, for whatever reason corrupted or does not reach
its intended recipient. No warranty is given that this email is free of viruses. The
views expressed in this email are, unless otherwise stated, those of the author and
not those of the Company or its management. The Company reserves the right to monitor,
intercept and block emails addressed to its users or take any other action in accordance
with its email use policy.
------------
This message (including any attachments) contains confidential information intended
for a specific individual and purpose, and is protected by law. If you are not the
intended recipient, you should delete this message and hereby notified that any
disclosure, copying, or distribution of this message (or any part thereof), or the
taking of any action based on it, is strictly prohibited. No liability or responsibility
is accepted if information or data is, for whatever reason corrupted or does not reach
its intended recipient. No warranty is given that this email is free of viruses. The
views expressed in this email are, unless otherwise stated, those of the author and
not those of the Company or its management. The Company reserves the right to monitor,
intercept and block emails addressed to its users or take any other action in accordance
with its email use policy.
------------
This message (including any attachments) contains confidential information intended
for a specific individual and purpose, and is protected by law. If you are not the
intended recipient, you should delete this message and hereby notified that any
disclosure, copying, or distribution of this message (or any part thereof), or the
taking of any action based on it, is strictly prohibited. No liability or responsibility
is accepted if information or data is, for whatever reason corrupted or does not reach
its intended recipient. No warranty is given that this email is free of viruses. The
views expressed in this email are, unless otherwise stated, those of the author and
not those of the Company or its management. The Company reserves the right to monitor,
intercept and block emails addressed to its users or take any other action in accordance
with its email use policy.
Tue Oct 27, 2015 12:03 am (PDT) . Posted by:
"Heri Pamungkas ( Gmail )" dchoosen88
السَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
Semangat pagi,.
Itu karena bapak mencoba save File ber-VBA ke Format File yang
tidak support VBA.
Caranya, coba save as ke File Format :
_*Excel Macro-Enabled Workbook*_ atau_*Excel Binary Workbook*_
وَالسَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
Warm Regards,
On 27/10/2015 13:34, Samsudin samsudin@bayan.com.sg [belajar-excel] wrote:
>
> Pak Heri,
>
> Berikut kendala lagi muncul sbb :
>
> Pada saat saya mau menyimpan file tersebut muncul peringatan seperti
> tersebut di atas, bagaimana menyelesaikan masalah ini, mohon
> bantuannya kepada master excel yang lainnya.
>
> *Terima kasih*
>
> *Samsudin*
>
> *From:*belajar-excel@yahoogroups.com
> [mailto:belajar-excel@yahoogroups.com]
> *Sent:* Tuesday, October 27, 2015 1:53 PM
> *To:* belajar-excel@yahoogroups.com
> *Subject:* Re: [belajar-excel] membuat jam digital [1 Attachment]
>
>
>
> السَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
> Semangat pagi,.
>
> Komputer Saya menggunakan Office 2010.
> Dan hasilnya bisa Jalan Normal...
>
>
>
>
>
> وَالسَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
>
> Warm Regards,
>
> On 27/10/2015 7:23, Samsudin samsudin@bayan.com.sg
> <mailto:samsudin@bayan.com.sg> [belajar-excel] wrote:
>
> Pak Herri,
>
> Terima kasih infonya dan kalau boleh tahu bapak menggunakan
> Microsoft office berapa, sebagai informasi saya menggunakan
> computer perusahaan (semua program berlisensi resmi) dan munculnya
> seperti :
>
> Dim TampilkanWaktu
>
> Sub JamDigital()
>
> Set Sh = ThisWorkbook.Sheets(1)
>
> Sh.Calculate
>
> With Sh.Range("B5")
>
> .FormulaR1C1 = "=Now()"
>
> .NumberFormat = "hh:mm:ss AM/PM"
>
> End With
>
> TampilkanWaktu = Now + TimeValue("00:00:01")
>
> Application.OnTime TampilkanWaktu, "Jamdigital"
>
> End Sub
>
> Dan jika makro di run maka : Compile error: Variable not defined
> dan crusor mengarah keSh.
>
> *Terima kasih*
>
> **
>
> *Samsudin*
>
> *From:*belajar-excel@yahoogroups.com
> <mailto:belajar-excel@yahoogroups.com>
> [mailto:belajar-excel@yahoogroups.com]
> *Sent:* Monday, October 26, 2015 9:24 PM
> *To:* belajar-excel@yahoogroups.com
> <mailto:belajar-excel@yahoogroups.com>
> *Subject:* Re: [belajar-excel] membuat jam digital
>
>
>
>
> السَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
>
> Semangat pagi,.
>
>
>
> Alhamdulillah di komputer saya
>
> Script bapak berjalan lancar kok.
>
>
>
>
>
>
>
> وَالسَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
>
>
>
> Warm Regards,
>
> On 26/10/2015 16:30, Samsudin samsudin@bayan.com.sg
> <mailto:samsudin@bayan.com.sg> [belajar-excel] wrote:
>
> Dear Master Excel,
>
> Bagaimana caranya script untuk menampilkan jam digital pada
> excel bisa berfungsi, karena saya sudah mencobanya tetapi
> tidak berhasil, masalahnya dimana?
>
> Berikut script :
>
> Script :
>
> Dim TampilkanWaktu
>
> Sub JamDigital()
>
> Set Sh = ThisWorkbook.
>
> Sh.Calculate
>
>
> With Sh.Range("
>
> .FormulaR1C1 = "=Now()
>
> .NumberFormat = "hh:mm:
>
> End With
>
>
> TampilkanWaktu = Now + TimeValue("
>
> Application.
>
> End Sub
>
> *Terima kasih*
>
> *Samsudin*
>
> ------------
>
>
>
>
>
> This message (including any attachments) contains confidential information intended
>
> for a specific individual and purpose, and is protected by law. If you are not the
>
> intended recipient, you should delete this message and hereby notified that any
>
> disclosure, copying, or distribution of this message (or any part thereof), or the
>
> taking of any action based on it, is strictly prohibited. No liability or responsibility
>
> is accepted if information or data is, for whatever reason corrupted or does not reach
>
> its intended recipient. No warranty is given that this email is free of viruses. The
>
> views expressed in this email are, unless otherwise stated, those of the author and
>
> not those of the Company or its management. The Company reserves the right to monitor,
>
> intercept and block emails addressed to its users or take any other action in accordance
>
> with its email use policy.
>
> ------------
>
>
>
> This message (including any attachments) contains confidential information intended
>
> for a specific individual and purpose, and is protected by law. If you are not the
>
> intended recipient, you should delete this message and hereby notified that any
>
> disclosure, copying, or distribution of this message (or any part thereof), or the
>
> taking of any action based on it, is strictly prohibited. No liability or responsibility
>
> is accepted if information or data is, for whatever reason corrupted or does not reach
>
> its intended recipient. No warranty is given that this email is free of viruses. The
>
> views expressed in this email are, unless otherwise stated, those of the author and
>
> not those of the Company or its management. The Company reserves the right to monitor,
>
> intercept and block emails addressed to its users or take any other action in accordance
>
> with its email use policy.
>
> ------------
>
> This message (including any attachments) contains confidential information intended
> for a specific individual and purpose, and is protected by law. If you are not the
> intended recipient, you should delete this message and hereby notified that any
> disclosure, copying, or distribution of this message (or any part thereof), or the
> taking of any action based on it, is strictly prohibited. No liability or responsibility
> is accepted if information or data is, for whatever reason corrupted or does not reach
> its intended recipient. No warranty is given that this email is free of viruses. The
> views expressed in this email are, unless otherwise stated, those of the author and
> not those of the Company or its management. The Company reserves the right to monitor,
> intercept and block emails addressed to its users or take any other action in accordance
> with its email use policy.
>
>
Mon Oct 26, 2015 11:35 pm (PDT) . Posted by:
"Muhammad Aswan"
Hallo BeExceller,
Saya anggota baru dimilis ini dan saya ingin belajar lebih mendalam.
Saya jg mau langsung bertanya, bagaimana mengelola supaya semua input data
pada sheet 'INPUT' masuk secara otomatis ke sheet 2 "BIRINGKANAYA (*sesuai
kecamatan*)" dan begitu ke sheet 3 (kecamatan lainnya).
Moga dapat menyelesaikan permasalahan kantor kami.
Contoh :
data terlampir (database 2015)
Regards
Saya anggota baru dimilis ini dan saya ingin belajar lebih mendalam.
Saya jg mau langsung bertanya, bagaimana mengelola supaya semua input data
pada sheet 'INPUT&#
kecamatan*)" dan begitu ke sheet 3 (kecamatan lainnya).
Moga dapat menyelesaikan permasalahan kantor kami.
Contoh :
data terlampir (database 2015)
Regards
Tue Oct 27, 2015 1:16 am (PDT) . Posted by:
"hendrik karnadi" hendrikkarnadi
Hai M. Aswan,Coba dipelajari file mbak Siti yang saya lampirkan.
Kuncinya:- Membuat Unique Value dari nama2 Kecamatan- Mengcopy setiap data yang ada dalam sheet Master ke sheet masing2 Kecamatan (termasuk judulnya).
Salam,HK
From: "Muhammad Aswan aswandtrb17@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Tuesday, 27 October 2015, 13:09
Subject: [belajar-excel] INPUT OTOMATIS KE SHEET LAIN [1 Attachment]
Hallo BeExceller,
Saya anggota baru dimilis ini dan saya ingin belajar lebih mendalam.
Saya jg mau langsung bertanya, bagaimana mengelola supaya semua input data pada sheet 'INPUT' masuk secara otomatis ke sheet 2 "BIRINGKANAYA (sesuai kecamatan)" dan begitu ke sheet 3 (kecamatan lainnya).
Moga dapat menyelesaikan permasalahan kantor kami.
Contoh :
data terlampir (database 2015)
Regards #yiv1189853300 #yiv1189853300 -- #yiv1189853300ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1189853300 #yiv1189853300ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1189853300 #yiv1189853300ygrp-mkp #yiv1189853300hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1189853300 #yiv1189853300ygrp-mkp #yiv1189853300ads {margin-bottom:10px;}#yiv1189853300 #yiv1189853300ygrp-mkp .yiv1189853300ad {padding:0 0;}#yiv1189853300 #yiv1189853300ygrp-mkp .yiv1189853300ad p {margin:0;}#yiv1189853300 #yiv1189853300ygrp-mkp .yiv1189853300ad a {color:#0000ff;text-decoration:none;}#yiv1189853300 #yiv1189853300ygrp-sponsor #yiv1189853300ygrp-lc {font-family:Arial;}#yiv1189853300 #yiv1189853300ygrp-sponsor #yiv1189853300ygrp-lc #yiv1189853300hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1189853300 #yiv1189853300ygrp-sponsor #yiv1189853300ygrp-lc .yiv1189853300ad {margin-bottom:10px;padding:0 0;}#yiv1189853300 #yiv1189853300actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1189853300 #yiv1189853300activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1189853300 #yiv1189853300activity span {font-weight:700;}#yiv1189853300 #yiv1189853300activity span:first-child {text-transform:uppercase;}#yiv1189853300 #yiv1189853300activity span a {color:#5085b6;text-decoration:none;}#yiv1189853300 #yiv1189853300activity span span {color:#ff7900;}#yiv1189853300 #yiv1189853300activity span .yiv1189853300underline {text-decoration:underline;}#yiv1189853300 .yiv1189853300attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1189853300 .yiv1189853300attach div a {text-decoration:none;}#yiv1189853300 .yiv1189853300attach img {border:none;padding-right:5px;}#yiv1189853300 .yiv1189853300attach label {display:block;margin-bottom:5px;}#yiv1189853300 .yiv1189853300attach label a {text-decoration:none;}#yiv1189853300 blockquote {margin:0 0 0 4px;}#yiv1189853300 .yiv1189853300bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1189853300 .yiv1189853300bold a {text-decoration:none;}#yiv1189853300 dd.yiv1189853300last p a {font-family:Verdana;font-weight:700;}#yiv1189853300 dd.yiv1189853300last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1189853300 dd.yiv1189853300last p span.yiv1189853300yshortcuts {margin-right:0;}#yiv1189853300 div.yiv1189853300attach-table div div a {text-decoration:none;}#yiv1189853300 div.yiv1189853300attach-table {width:400px;}#yiv1189853300 div.yiv1189853300file-title a, #yiv1189853300 div.yiv1189853300file-title a:active, #yiv1189853300 div.yiv1189853300file-title a:hover, #yiv1189853300 div.yiv1189853300file-title a:visited {text-decoration:none;}#yiv1189853300 div.yiv1189853300photo-title a, #yiv1189853300 div.yiv1189853300photo-title a:active, #yiv1189853300 div.yiv1189853300photo-title a:hover, #yiv1189853300 div.yiv1189853300photo-title a:visited {text-decoration:none;}#yiv1189853300 div#yiv1189853300ygrp-mlmsg #yiv1189853300ygrp-msg p a span.yiv1189853300yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1189853300 .yiv1189853300green {color:#628c2a;}#yiv1189853300 .yiv1189853300MsoNormal {margin:0 0 0 0;}#yiv1189853300 o {font-size:0;}#yiv1189853300 #yiv1189853300photos div {float:left;width:72px;}#yiv1189853300 #yiv1189853300photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv1189853300 #yiv1189853300photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1189853300 #yiv1189853300reco-category {font-size:77%;}#yiv1189853300 #yiv1189853300reco-desc {font-size:77%;}#yiv1189853300 .yiv1189853300replbq {margin:4px;}#yiv1189853300 #yiv1189853300ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1189853300 #yiv1189853300ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1189853300 #yiv1189853300ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1189853300 #yiv1189853300ygrp-mlmsg select, #yiv1189853300 input, #yiv1189853300 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1189853300 #yiv1189853300ygrp-mlmsg pre, #yiv1189853300 code {font:115% monospace;}#yiv1189853300 #yiv1189853300ygrp-mlmsg * {line-height:1.22em;}#yiv1189853300 #yiv1189853300ygrp-mlmsg #yiv1189853300logo {padding-bottom:10px;}#yiv1189853300 #yiv1189853300ygrp-msg p a {font-family:Verdana;}#yiv1189853300 #yiv1189853300ygrp-msg p#yiv1189853300attach-count span {color:#1E66AE;font-weight:700;}#yiv1189853300 #yiv1189853300ygrp-reco #yiv1189853300reco-head {color:#ff7900;font-weight:700;}#yiv1189853300 #yiv1189853300ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1189853300 #yiv1189853300ygrp-sponsor #yiv1189853300ov li a {font-size:130%;text-decoration:none;}#yiv1189853300 #yiv1189853300ygrp-sponsor #yiv1189853300ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1189853300 #yiv1189853300ygrp-sponsor #yiv1189853300ov ul {margin:0;padding:0 0 0 8px;}#yiv1189853300 #yiv1189853300ygrp-text {font-family:Georgia;}#yiv1189853300 #yiv1189853300ygrp-text p {margin:0 0 1em 0;}#yiv1189853300 #yiv1189853300ygrp-text tt {font-size:120%;}#yiv1189853300 #yiv1189853300ygrp-vital ul li:last-child {border-right:none !important;}#yiv1189853300
Kuncinya:- Membuat Unique Value dari nama2 Kecamatan- Mengcopy setiap data yang ada dalam sheet Master ke sheet masing2 Kecamatan (termasuk judulnya).
Salam,HK
From: "Muhammad Aswan aswandtrb17@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Tuesday, 27 October 2015, 13:09
Subject: [belajar-excel] INPUT OTOMATIS KE SHEET LAIN [1 Attachment]
Hallo BeExceller,
Saya anggota baru dimilis ini dan saya ingin belajar lebih mendalam.
Saya jg mau langsung bertanya, bagaimana mengelola supaya semua input data pada sheet 'INPUT&#
Moga dapat menyelesaikan permasalahan kantor kami.
Contoh :
data terlampir (database 2015)
Regards #yiv1189853300 #yiv1189853300 -- #yiv1189853300ygrp-
============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------
Tidak ada komentar:
Posting Komentar