Kamis, 07 Januari 2016

[belajar-excel] Digest Number 3712

15 Messages

Digest #3712
1
(no subject) by "Pauzan Ozan" b3ki_cot
2a
Combobox dan Checkbox by "Danny Prasetyo" danny_06791
2b
Re: Combobox dan Checkbox [1 Attachment] by "Mr. Kid" nmkid.family@ymail.com
6b
7a
user form not responding by "imam cahyo yuwono"
7d
Re: Bls: [belajar-excel] user form not responding by "Mr. Kid" nmkid.family@ymail.com
8
Auto Color by "Subroto, Matzen"

Messages

Wed Jan 6, 2016 4:16 am (PST) . Posted by:

"Pauzan Ozan" b3ki_cot

Lampiran hapus no_tetap urut

Wed Jan 6, 2016 4:21 am (PST) . Posted by:

"Danny Prasetyo" danny_06791

body { font-family: "Calibri","Slate
Pro",sans-serif,"sans-serif"; color:#262626 } Para master Excel,
tolong dibantu dong. Saya ada kesulitan nih.
Regards,

Danny Prasetyo

Wed Jan 6, 2016 8:16 pm (PST) . Posted by:

"Mr. Kid" nmkid.family@ymail.com

Hai Danny,

Boleh bertanya kan ya...
Tolong dibantu, bagaimana menentukan bahwa data saya berikut ini ada 3
person yang Laki-Laki
Nama
A
B
C
D
E
F
G

Yang manakah dari 7 person dalam daftar Nama tersebut yang laki-laki ?
Sepertinya sih ada 3...

Terimakasih

2016-01-06 16:51 GMT+07:00 Danny Prasetyo danny_06791@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com>:

>
>
> Para master Excel, tolong dibantu dong.
> Saya ada kesulitan nih.
>
> Regards,
>
> Danny Prasetyo
>
>
>

Wed Jan 6, 2016 6:14 am (PST) . Posted by:

"Hendrik Karnadi" hendrikkarnadi

Dear Be-Exceler,
Untuk teman2 peminat VBA yang ingin memanfaatkan file2 yang ada dalam folder HK_Books yang saya share di Dropbox, dengan ini saya ingatkan untuk TIDAK MERUBAH, MEMINDAHKAN, MENGAMBIL atau MENDELETE file2 tsb demi kepentingan bersama.
Anda HANYA BOLEH MENDOWNLOAD.

Kepada mereka yang telah melakukan hal2 yang TIDAK SESUAI ETIKA tsb, dengan ini saya minta untuk TIDAK MENGULANGI lagi krn tindakan anda SANGAT MERUGIKAN teman2 lainnya.

Terima kasih.

Salam,
HK

Sent from Samsung Mobile

<div>-------- Original message --------</div><div>From: Dropbox <no-reply@dropboxmail.com> </div><div>Date:06/01/2016 7:17 PM (GMT+07:00) </div><div>To: hendrikkarnadi@yahoo.com </div><div>Subject: Qudsiyyah and 1 other made changes in your shared folders </div><div>
</div>
HERE'S WHAT HAPPENED IN YOUR SHARED FOLDERS LAST WEEK
HK_Books

Des 2008 Kosong_Formula.xls
Edited in PLKT by Qudsiyyah Tuesday 1/5/2016

Des 2008 Kosong_Formula.xls
Edited in PLKT1 by enrico Tuesday 1/5/2016

Good things happen when your stuff lives here
Files in shared folders are automatically updated whenever anyone makes a change. Learn more.
Don't want these weekly digests? Unsubscribe.
© 2016 Dropbox, PO Box 77767, San Francisco, CA 94107

Wed Jan 6, 2016 7:36 pm (PST) . Posted by:

"Mts Qudsiyyah" mts_qudsiyyah_kudus

ya terimakasih atas ilmunya


Pada Rabu, 6 Januari 2016 21:14, "Hendrik Karnadi hendrikkarnadi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Dear Be-Exceler,Untuk teman2 peminat VBA yang ingin memanfaatkan file2 yang ada dalam folder HK_Books yang saya share di Dropbox, dengan ini saya ingatkan untuk TIDAK MERUBAH, MEMINDAHKAN, MENGAMBIL atau MENDELETE file2 tsb demi kepentingan bersama.Anda HANYA BOLEH MENDOWNLOAD.
Kepada mereka yang telah melakukan hal2 yang TIDAK SESUAI ETIKA tsb, dengan ini saya minta untuk TIDAK MENGULANGI lagi krn tindakan anda SANGAT MERUGIKAN teman2 lainnya.
Terima kasih.
Salam,HK
Sent from Samsung Mobile

-------- Original message --------From: Dropbox Date:06/01/2016 7:17 PM (GMT+07:00) To: hendrikkarnadi@yahoo.com Subject: Qudsiyyah and 1 other made changes in your shared folders

|
|
| |
| |
|
| |
| |
| Here's what happened in your shared folders last week |

|
|
|
| |
| | | HK_Books | |
| |

|
|
| | |
| Des 2008 Kosong_Formula.xls |
| Edited in PLKT by Qudsiyyah Tuesday 1/5/2016 |

|
| |

|
|
| | |
| Des 2008 Kosong_Formula.xls |
| Edited in PLKT1 by enrico Tuesday 1/5/2016 |

|
| |

|
|
| |

|

|
|
| |
| | |
| Good things happen when your stuff lives here |
| Files in shared folders are automatically updated whenever anyone makes a change. Learn more. |

|

|
|
| |
| |

|
|
| Don't want these weekly digests? Unsubscribe. |
| © 2016 Dropbox, PO Box 77767, San Francisco, CA 94107 |

|

| |
| |

|

| |
|
|

|

|

#yiv6916515006 #yiv6916515006 -- #yiv6916515006ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6916515006 #yiv6916515006ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6916515006 #yiv6916515006ygrp-mkp #yiv6916515006hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6916515006 #yiv6916515006ygrp-mkp #yiv6916515006ads {margin-bottom:10px;}#yiv6916515006 #yiv6916515006ygrp-mkp .yiv6916515006ad {padding:0 0;}#yiv6916515006 #yiv6916515006ygrp-mkp .yiv6916515006ad p {margin:0;}#yiv6916515006 #yiv6916515006ygrp-mkp .yiv6916515006ad a {color:#0000ff;text-decoration:none;}#yiv6916515006 #yiv6916515006ygrp-sponsor #yiv6916515006ygrp-lc {font-family:Arial;}#yiv6916515006 #yiv6916515006ygrp-sponsor #yiv6916515006ygrp-lc #yiv6916515006hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6916515006 #yiv6916515006ygrp-sponsor #yiv6916515006ygrp-lc .yiv6916515006ad {margin-bottom:10px;padding:0 0;}#yiv6916515006 #yiv6916515006actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6916515006 #yiv6916515006activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6916515006 #yiv6916515006activity span {font-weight:700;}#yiv6916515006 #yiv6916515006activity span:first-child {text-transform:uppercase;}#yiv6916515006 #yiv6916515006activity span a {color:#5085b6;text-decoration:none;}#yiv6916515006 #yiv6916515006activity span span {color:#ff7900;}#yiv6916515006 #yiv6916515006activity span .yiv6916515006underline {text-decoration:underline;}#yiv6916515006 .yiv6916515006attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6916515006 .yiv6916515006attach div a {text-decoration:none;}#yiv6916515006 .yiv6916515006attach img {border:none;padding-right:5px;}#yiv6916515006 .yiv6916515006attach label {display:block;margin-bottom:5px;}#yiv6916515006 .yiv6916515006attach label a {text-decoration:none;}#yiv6916515006 blockquote {margin:0 0 0 4px;}#yiv6916515006 .yiv6916515006bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6916515006 .yiv6916515006bold a {text-decoration:none;}#yiv6916515006 dd.yiv6916515006last p a {font-family:Verdana;font-weight:700;}#yiv6916515006 dd.yiv6916515006last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6916515006 dd.yiv6916515006last p span.yiv6916515006yshortcuts {margin-right:0;}#yiv6916515006 div.yiv6916515006attach-table div div a {text-decoration:none;}#yiv6916515006 div.yiv6916515006attach-table {width:400px;}#yiv6916515006 div.yiv6916515006file-title a, #yiv6916515006 div.yiv6916515006file-title a:active, #yiv6916515006 div.yiv6916515006file-title a:hover, #yiv6916515006 div.yiv6916515006file-title a:visited {text-decoration:none;}#yiv6916515006 div.yiv6916515006photo-title a, #yiv6916515006 div.yiv6916515006photo-title a:active, #yiv6916515006 div.yiv6916515006photo-title a:hover, #yiv6916515006 div.yiv6916515006photo-title a:visited {text-decoration:none;}#yiv6916515006 div#yiv6916515006ygrp-mlmsg #yiv6916515006ygrp-msg p a span.yiv6916515006yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6916515006 .yiv6916515006green {color:#628c2a;}#yiv6916515006 .yiv6916515006MsoNormal {margin:0 0 0 0;}#yiv6916515006 o {font-size:0;}#yiv6916515006 #yiv6916515006photos div {float:left;width:72px;}#yiv6916515006 #yiv6916515006photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv6916515006 #yiv6916515006photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6916515006 #yiv6916515006reco-category {font-size:77%;}#yiv6916515006 #yiv6916515006reco-desc {font-size:77%;}#yiv6916515006 .yiv6916515006replbq {margin:4px;}#yiv6916515006 #yiv6916515006ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6916515006 #yiv6916515006ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6916515006 #yiv6916515006ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6916515006 #yiv6916515006ygrp-mlmsg select, #yiv6916515006 input, #yiv6916515006 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6916515006 #yiv6916515006ygrp-mlmsg pre, #yiv6916515006 code {font:115% monospace;}#yiv6916515006 #yiv6916515006ygrp-mlmsg * {line-height:1.22em;}#yiv6916515006 #yiv6916515006ygrp-mlmsg #yiv6916515006logo {padding-bottom:10px;}#yiv6916515006 #yiv6916515006ygrp-msg p a {font-family:Verdana;}#yiv6916515006 #yiv6916515006ygrp-msg p#yiv6916515006attach-count span {color:#1E66AE;font-weight:700;}#yiv6916515006 #yiv6916515006ygrp-reco #yiv6916515006reco-head {color:#ff7900;font-weight:700;}#yiv6916515006 #yiv6916515006ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6916515006 #yiv6916515006ygrp-sponsor #yiv6916515006ov li a {font-size:130%;text-decoration:none;}#yiv6916515006 #yiv6916515006ygrp-sponsor #yiv6916515006ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6916515006 #yiv6916515006ygrp-sponsor #yiv6916515006ov ul {margin:0;padding:0 0 0 8px;}#yiv6916515006 #yiv6916515006ygrp-text {font-family:Georgia;}#yiv6916515006 #yiv6916515006ygrp-text p {margin:0 0 1em 0;}#yiv6916515006 #yiv6916515006ygrp-text tt {font-size:120%;}#yiv6916515006 #yiv6916515006ygrp-vital ul li:last-child {border-right:none !important;}#yiv6916515006

Wed Jan 6, 2016 9:08 am (PST) . Posted by:

"Toby kenzo" tobykenzo

Hai Nursay,

Coba file ini..

TerimaKasih.

Sent from Yahoo Mail on Android

Wed Jan 6, 2016 6:57 pm (PST) . Posted by:

"Toby kenzo" tobykenzo

Dear Danny,

Coba di pasang formula ini di sub checkbox1_change dan sub checkbox2_change

If ComboBox2.Value = "Laki-laki" And Me.ComboBox1.Value = "Tukul" Then
Me.CheckBox1.Value = True
Me.CheckBox1.Enabled = False
ElseIf ComboBox2.Value = "Laki-laki" And Me.ComboBox1.Value = "Baim Wong" Then
Me.CheckBox1.Value = True
Me.CheckBox1.Enabled = False

ElseIf ComboBox2.Value = "Pria" And Me.ComboBox1.Value = "Baim Wong" Then
Me.CheckBox1.Value = True
Me.CheckBox1.Enabled = False

ElseIf ComboBox2.Value = "Pria" And Me.ComboBox1.Value = "Tukul" Then
Me.CheckBox1.Value = True
Me.CheckBox1.Enabled = False

Else
Me.CheckBox1.Value = False
Me.CheckBox1.Enabled = True

End If

TerimaKasih
--------------------------------------------
Pada Rab, 6/1/16, Danny Prasetyo danny_06791@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

Judul: [belajar-excel] Combobox dan Checkbox [1 Attachment]
Kepada: belajar-excel@yahoogroups.com
Tanggal: Rabu, 6 Januari, 2016, 4:51 PM


 









Para master Excel, tolong dibantu
dong. Saya ada kesulitan nih.
Regards, 

Danny Prasetyo 









#yiv9275466182 #yiv9275466182 --
#yiv9275466182ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv9275466182 #yiv9275466182ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv9275466182 #yiv9275466182ygrp-mkp #yiv9275466182hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv9275466182 #yiv9275466182ygrp-mkp #yiv9275466182ads {
margin-bottom:10px;}

#yiv9275466182 #yiv9275466182ygrp-mkp .yiv9275466182ad {
padding:0 0;}

#yiv9275466182 #yiv9275466182ygrp-mkp .yiv9275466182ad p {
margin:0;}

#yiv9275466182 #yiv9275466182ygrp-mkp .yiv9275466182ad a {
color:#0000ff;text-decoration:none;}
#yiv9275466182 #yiv9275466182ygrp-sponsor
#yiv9275466182ygrp-lc {
font-family:Arial;}

#yiv9275466182 #yiv9275466182ygrp-sponsor
#yiv9275466182ygrp-lc #yiv9275466182hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv9275466182 #yiv9275466182ygrp-sponsor
#yiv9275466182ygrp-lc .yiv9275466182ad {
margin-bottom:10px;padding:0 0;}

#yiv9275466182 #yiv9275466182actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv9275466182 #yiv9275466182activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv9275466182 #yiv9275466182activity span {
font-weight:700;}

#yiv9275466182 #yiv9275466182activity span:first-child {
text-transform:uppercase;}

#yiv9275466182 #yiv9275466182activity span a {
color:#5085b6;text-decoration:none;}

#yiv9275466182 #yiv9275466182activity span span {
color:#ff7900;}

#yiv9275466182 #yiv9275466182activity span
.yiv9275466182underline {
text-decoration:underline;}

#yiv9275466182 .yiv9275466182attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv9275466182 .yiv9275466182attach div a {
text-decoration:none;}

#yiv9275466182 .yiv9275466182attach img {
border:none;padding-right:5px;}

#yiv9275466182 .yiv9275466182attach label {
display:block;margin-bottom:5px;}

#yiv9275466182 .yiv9275466182attach label a {
text-decoration:none;}

#yiv9275466182 blockquote {
margin:0 0 0 4px;}

#yiv9275466182 .yiv9275466182bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv9275466182 .yiv9275466182bold a {
text-decoration:none;}

#yiv9275466182 dd.yiv9275466182last p a {
font-family:Verdana;font-weight:700;}

#yiv9275466182 dd.yiv9275466182last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv9275466182 dd.yiv9275466182last p
span.yiv9275466182yshortcuts {
margin-right:0;}

#yiv9275466182 div.yiv9275466182attach-table div div a {
text-decoration:none;}

#yiv9275466182 div.yiv9275466182attach-table {
width:400px;}

#yiv9275466182 div.yiv9275466182file-title a, #yiv9275466182
div.yiv9275466182file-title a:active, #yiv9275466182
div.yiv9275466182file-title a:hover, #yiv9275466182
div.yiv9275466182file-title a:visited {
text-decoration:none;}

#yiv9275466182 div.yiv9275466182photo-title a,
#yiv9275466182 div.yiv9275466182photo-title a:active,
#yiv9275466182 div.yiv9275466182photo-title a:hover,
#yiv9275466182 div.yiv9275466182photo-title a:visited {
text-decoration:none;}

#yiv9275466182 div#yiv9275466182ygrp-mlmsg
#yiv9275466182ygrp-msg p a span.yiv9275466182yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv9275466182 .yiv9275466182green {
color:#628c2a;}

#yiv9275466182 .yiv9275466182MsoNormal {
margin:0 0 0 0;}

#yiv9275466182 o {
font-size:0;}

#yiv9275466182 #yiv9275466182photos div {
float:left;width:72px;}

#yiv9275466182 #yiv9275466182photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv9275466182 #yiv9275466182photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv9275466182 #yiv9275466182reco-category {
font-size:77%;}

#yiv9275466182 #yiv9275466182reco-desc {
font-size:77%;}

#yiv9275466182 .yiv9275466182replbq {
margin:4px;}

#yiv9275466182 #yiv9275466182ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv9275466182 #yiv9275466182ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv9275466182 #yiv9275466182ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv9275466182 #yiv9275466182ygrp-mlmsg select,
#yiv9275466182 input, #yiv9275466182 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv9275466182 #yiv9275466182ygrp-mlmsg pre, #yiv9275466182
code {
font:115% monospace;}

#yiv9275466182 #yiv9275466182ygrp-mlmsg * {
line-height:1.22em;}

#yiv9275466182 #yiv9275466182ygrp-mlmsg #yiv9275466182logo {
padding-bottom:10px;}


#yiv9275466182 #yiv9275466182ygrp-msg p a {
font-family:Verdana;}

#yiv9275466182 #yiv9275466182ygrp-msg
p#yiv9275466182attach-count span {
color:#1E66AE;font-weight:700;}

#yiv9275466182 #yiv9275466182ygrp-reco
#yiv9275466182reco-head {
color:#ff7900;font-weight:700;}

#yiv9275466182 #yiv9275466182ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv9275466182 #yiv9275466182ygrp-sponsor #yiv9275466182ov
li a {
font-size:130%;text-decoration:none;}

#yiv9275466182 #yiv9275466182ygrp-sponsor #yiv9275466182ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv9275466182 #yiv9275466182ygrp-sponsor #yiv9275466182ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv9275466182 #yiv9275466182ygrp-text {
font-family:Georgia;}

#yiv9275466182 #yiv9275466182ygrp-text p {
margin:0 0 1em 0;}

#yiv9275466182 #yiv9275466182ygrp-text tt {
font-size:120%;}

#yiv9275466182 #yiv9275466182ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv9275466182

Wed Jan 6, 2016 7:32 pm (PST) . Posted by:

idz.iman

Hallo rekans Master.


Happy new year 2016 #telat :)


saya mau nanya nih, saya ada kesulitan untuk Short data dengan menggunakan rumus SUMIFS secara horizontal dan Vertikal.


mungkin lebih jelasnya bisa liat di file terlampir.


Terima kaasih sebelumnya.


salam
Iman DZ

Wed Jan 6, 2016 9:40 pm (PST) . Posted by:

"Mr. Kid" nmkid.family@ymail.com

Hai Iman,

Fungsi Index bisa dimanfaatkan. Contohnya seperti file terlampir.

Wassalam,
Kid

2016-01-07 10:32 GMT+07:00 idz.iman@yahoo.com [belajar-excel] <
belajar-excel@yahoogroups.com>:

>
>
> Hallo rekans Master.
>
>
> Happy new year 2016 #telat :)
>
>
> saya mau nanya nih, saya ada kesulitan untuk Short data dengan menggunakan
> rumus SUMIFS secara horizontal dan Vertikal.
>
>
> mungkin lebih jelasnya bisa liat di file terlampir.
>
>
> Terima kaasih sebelumnya.
>
>
> salam
>
> Iman DZ
>
>
>

Wed Jan 6, 2016 10:17 pm (PST) . Posted by:

"Iman Darusman" idz.iman

Hai Mr.Kid.
gimana sudah kembali ke Indonesia?
Btw ok banget pencerahannya, sepertinya harus saya harus mempelajari yang lebih luas tentang Fungsi Index.
Terima kasih Mr.Kid
salamIman

Pada Kamis, 7 Januari 2016 12:40, "'Mr. Kid' mr.nmkid@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Hai Iman,

Fungsi Index bisa dimanfaatkan. Contohnya seperti file terlampir.

Wassalam,
Kid

2016-01-07 10:32 GMT+07:00 idz.iman@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>:

  Hallo rekans Master.
Happy new year 2016 #telat :)
saya mau nanya nih, saya ada kesulitan untuk Short data dengan menggunakan rumus SUMIFS secara horizontal dan Vertikal.
mungkin lebih jelasnya bisa liat di file terlampir.
Terima kaasih sebelumnya.
salamIman DZ

#yiv2546323848 #yiv2546323848 -- #yiv2546323848ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2546323848 #yiv2546323848ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2546323848 #yiv2546323848ygrp-mkp #yiv2546323848hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2546323848 #yiv2546323848ygrp-mkp #yiv2546323848ads {margin-bottom:10px;}#yiv2546323848 #yiv2546323848ygrp-mkp .yiv2546323848ad {padding:0 0;}#yiv2546323848 #yiv2546323848ygrp-mkp .yiv2546323848ad p {margin:0;}#yiv2546323848 #yiv2546323848ygrp-mkp .yiv2546323848ad a {color:#0000ff;text-decoration:none;}#yiv2546323848 #yiv2546323848ygrp-sponsor #yiv2546323848ygrp-lc {font-family:Arial;}#yiv2546323848 #yiv2546323848ygrp-sponsor #yiv2546323848ygrp-lc #yiv2546323848hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2546323848 #yiv2546323848ygrp-sponsor #yiv2546323848ygrp-lc .yiv2546323848ad {margin-bottom:10px;padding:0 0;}#yiv2546323848 #yiv2546323848actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2546323848 #yiv2546323848activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2546323848 #yiv2546323848activity span {font-weight:700;}#yiv2546323848 #yiv2546323848activity span:first-child {text-transform:uppercase;}#yiv2546323848 #yiv2546323848activity span a {color:#5085b6;text-decoration:none;}#yiv2546323848 #yiv2546323848activity span span {color:#ff7900;}#yiv2546323848 #yiv2546323848activity span .yiv2546323848underline {text-decoration:underline;}#yiv2546323848 .yiv2546323848attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2546323848 .yiv2546323848attach div a {text-decoration:none;}#yiv2546323848 .yiv2546323848attach img {border:none;padding-right:5px;}#yiv2546323848 .yiv2546323848attach label {display:block;margin-bottom:5px;}#yiv2546323848 .yiv2546323848attach label a {text-decoration:none;}#yiv2546323848 blockquote {margin:0 0 0 4px;}#yiv2546323848 .yiv2546323848bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2546323848 .yiv2546323848bold a {text-decoration:none;}#yiv2546323848 dd.yiv2546323848last p a {font-family:Verdana;font-weight:700;}#yiv2546323848 dd.yiv2546323848last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2546323848 dd.yiv2546323848last p span.yiv2546323848yshortcuts {margin-right:0;}#yiv2546323848 div.yiv2546323848attach-table div div a {text-decoration:none;}#yiv2546323848 div.yiv2546323848attach-table {width:400px;}#yiv2546323848 div.yiv2546323848file-title a, #yiv2546323848 div.yiv2546323848file-title a:active, #yiv2546323848 div.yiv2546323848file-title a:hover, #yiv2546323848 div.yiv2546323848file-title a:visited {text-decoration:none;}#yiv2546323848 div.yiv2546323848photo-title a, #yiv2546323848 div.yiv2546323848photo-title a:active, #yiv2546323848 div.yiv2546323848photo-title a:hover, #yiv2546323848 div.yiv2546323848photo-title a:visited {text-decoration:none;}#yiv2546323848 div#yiv2546323848ygrp-mlmsg #yiv2546323848ygrp-msg p a span.yiv2546323848yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2546323848 .yiv2546323848green {color:#628c2a;}#yiv2546323848 .yiv2546323848MsoNormal {margin:0 0 0 0;}#yiv2546323848 o {font-size:0;}#yiv2546323848 #yiv2546323848photos div {float:left;width:72px;}#yiv2546323848 #yiv2546323848photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv2546323848 #yiv2546323848photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2546323848 #yiv2546323848reco-category {font-size:77%;}#yiv2546323848 #yiv2546323848reco-desc {font-size:77%;}#yiv2546323848 .yiv2546323848replbq {margin:4px;}#yiv2546323848 #yiv2546323848ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2546323848 #yiv2546323848ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2546323848 #yiv2546323848ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2546323848 #yiv2546323848ygrp-mlmsg select, #yiv2546323848 input, #yiv2546323848 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2546323848 #yiv2546323848ygrp-mlmsg pre, #yiv2546323848 code {font:115% monospace;}#yiv2546323848 #yiv2546323848ygrp-mlmsg * {line-height:1.22em;}#yiv2546323848 #yiv2546323848ygrp-mlmsg #yiv2546323848logo {padding-bottom:10px;}#yiv2546323848 #yiv2546323848ygrp-msg p a {font-family:Verdana;}#yiv2546323848 #yiv2546323848ygrp-msg p#yiv2546323848attach-count span {color:#1E66AE;font-weight:700;}#yiv2546323848 #yiv2546323848ygrp-reco #yiv2546323848reco-head {color:#ff7900;font-weight:700;}#yiv2546323848 #yiv2546323848ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2546323848 #yiv2546323848ygrp-sponsor #yiv2546323848ov li a {font-size:130%;text-decoration:none;}#yiv2546323848 #yiv2546323848ygrp-sponsor #yiv2546323848ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2546323848 #yiv2546323848ygrp-sponsor #yiv2546323848ov ul {margin:0;padding:0 0 0 8px;}#yiv2546323848 #yiv2546323848ygrp-text {font-family:Georgia;}#yiv2546323848 #yiv2546323848ygrp-text p {margin:0 0 1em 0;}#yiv2546323848 #yiv2546323848ygrp-text tt {font-size:120%;}#yiv2546323848 #yiv2546323848ygrp-vital ul li:last-child {border-right:none !important;}#yiv2546323848

Wed Jan 6, 2016 7:36 pm (PST) . Posted by:

"imam cahyo yuwono"

Assalamualaikaum Wr. Wb.Dear para master saya membuat user form dai excel namun ketika ditampilkan malah not responding munculnya aga lama kira-kira penyebabnya apa ya ?terima kasih
Wasalammualaikum Wr. Wb.

Wed Jan 6, 2016 7:40 pm (PST) . Posted by:

"Iman Darusman" idz.iman

Dear Pak Imam.
Pengalaman saya, itu karena autosave nya aktif. coba saja di non aktifkan dengan cara :
file => Option => save => unchecklist pada "save auto recover"
semoga info ini membantu

salamIman DZ

Pada Kamis, 7 Januari 2016 10:36, "imam cahyo yuwono chyywn@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Assalamualaikaum Wr. Wb.Dear para master saya membuat user form dai excel namun ketika ditampilkan malah not responding munculnya aga lama kira-kira penyebabnya apa ya ?terima kasih
Wasalammualaikum Wr. Wb.
#yiv8335633926 #yiv8335633926 -- #yiv8335633926ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8335633926 #yiv8335633926ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8335633926 #yiv8335633926ygrp-mkp #yiv8335633926hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8335633926 #yiv8335633926ygrp-mkp #yiv8335633926ads {margin-bottom:10px;}#yiv8335633926 #yiv8335633926ygrp-mkp .yiv8335633926ad {padding:0 0;}#yiv8335633926 #yiv8335633926ygrp-mkp .yiv8335633926ad p {margin:0;}#yiv8335633926 #yiv8335633926ygrp-mkp .yiv8335633926ad a {color:#0000ff;text-decoration:none;}#yiv8335633926 #yiv8335633926ygrp-sponsor #yiv8335633926ygrp-lc {font-family:Arial;}#yiv8335633926 #yiv8335633926ygrp-sponsor #yiv8335633926ygrp-lc #yiv8335633926hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8335633926 #yiv8335633926ygrp-sponsor #yiv8335633926ygrp-lc .yiv8335633926ad {margin-bottom:10px;padding:0 0;}#yiv8335633926 #yiv8335633926actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8335633926 #yiv8335633926activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8335633926 #yiv8335633926activity span {font-weight:700;}#yiv8335633926 #yiv8335633926activity span:first-child {text-transform:uppercase;}#yiv8335633926 #yiv8335633926activity span a {color:#5085b6;text-decoration:none;}#yiv8335633926 #yiv8335633926activity span span {color:#ff7900;}#yiv8335633926 #yiv8335633926activity span .yiv8335633926underline {text-decoration:underline;}#yiv8335633926 .yiv8335633926attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8335633926 .yiv8335633926attach div a {text-decoration:none;}#yiv8335633926 .yiv8335633926attach img {border:none;padding-right:5px;}#yiv8335633926 .yiv8335633926attach label {display:block;margin-bottom:5px;}#yiv8335633926 .yiv8335633926attach label a {text-decoration:none;}#yiv8335633926 blockquote {margin:0 0 0 4px;}#yiv8335633926 .yiv8335633926bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8335633926 .yiv8335633926bold a {text-decoration:none;}#yiv8335633926 dd.yiv8335633926last p a {font-family:Verdana;font-weight:700;}#yiv8335633926 dd.yiv8335633926last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8335633926 dd.yiv8335633926last p span.yiv8335633926yshortcuts {margin-right:0;}#yiv8335633926 div.yiv8335633926attach-table div div a {text-decoration:none;}#yiv8335633926 div.yiv8335633926attach-table {width:400px;}#yiv8335633926 div.yiv8335633926file-title a, #yiv8335633926 div.yiv8335633926file-title a:active, #yiv8335633926 div.yiv8335633926file-title a:hover, #yiv8335633926 div.yiv8335633926file-title a:visited {text-decoration:none;}#yiv8335633926 div.yiv8335633926photo-title a, #yiv8335633926 div.yiv8335633926photo-title a:active, #yiv8335633926 div.yiv8335633926photo-title a:hover, #yiv8335633926 div.yiv8335633926photo-title a:visited {text-decoration:none;}#yiv8335633926 div#yiv8335633926ygrp-mlmsg #yiv8335633926ygrp-msg p a span.yiv8335633926yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8335633926 .yiv8335633926green {color:#628c2a;}#yiv8335633926 .yiv8335633926MsoNormal {margin:0 0 0 0;}#yiv8335633926 o {font-size:0;}#yiv8335633926 #yiv8335633926photos div {float:left;width:72px;}#yiv8335633926 #yiv8335633926photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv8335633926 #yiv8335633926photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8335633926 #yiv8335633926reco-category {font-size:77%;}#yiv8335633926 #yiv8335633926reco-desc {font-size:77%;}#yiv8335633926 .yiv8335633926replbq {margin:4px;}#yiv8335633926 #yiv8335633926ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8335633926 #yiv8335633926ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8335633926 #yiv8335633926ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8335633926 #yiv8335633926ygrp-mlmsg select, #yiv8335633926 input, #yiv8335633926 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8335633926 #yiv8335633926ygrp-mlmsg pre, #yiv8335633926 code {font:115% monospace;}#yiv8335633926 #yiv8335633926ygrp-mlmsg * {line-height:1.22em;}#yiv8335633926 #yiv8335633926ygrp-mlmsg #yiv8335633926logo {padding-bottom:10px;}#yiv8335633926 #yiv8335633926ygrp-msg p a {font-family:Verdana;}#yiv8335633926 #yiv8335633926ygrp-msg p#yiv8335633926attach-count span {color:#1E66AE;font-weight:700;}#yiv8335633926 #yiv8335633926ygrp-reco #yiv8335633926reco-head {color:#ff7900;font-weight:700;}#yiv8335633926 #yiv8335633926ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8335633926 #yiv8335633926ygrp-sponsor #yiv8335633926ov li a {font-size:130%;text-decoration:none;}#yiv8335633926 #yiv8335633926ygrp-sponsor #yiv8335633926ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8335633926 #yiv8335633926ygrp-sponsor #yiv8335633926ov ul {margin:0;padding:0 0 0 8px;}#yiv8335633926 #yiv8335633926ygrp-text {font-family:Georgia;}#yiv8335633926 #yiv8335633926ygrp-text p {margin:0 0 1em 0;}#yiv8335633926 #yiv8335633926ygrp-text tt {font-size:120%;}#yiv8335633926 #yiv8335633926ygrp-vital ul li:last-child {border-right:none !important;}#yiv8335633926

Wed Jan 6, 2016 11:45 pm (PST) . Posted by:

"imam cahyo yuwono"

terima kasih sebelumnya sudah saya coba namun tetap tidak ada perubahan mungkin comp nya ya.. di task manager performa CPU meningkat ketika user form di munculkan setelah tampilan ada turun lagi
terima kasih pa Iman nambah referensi saya ....


On Thursday, January 7, 2016 10:40 AM, "Iman Darusman idz.iman@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:


  Dear Pak Imam.
Pengalaman saya, itu karena autosave nya aktif. coba saja di non aktifkan dengan cara :
file => Option => save => unchecklist pada "save auto recover"
semoga info ini membantu

salamIman DZ

Pada Kamis, 7 Januari 2016 10:36, "imam cahyo yuwono chyywn@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Assalamualaikaum Wr. Wb.Dear para master saya membuat user form dai excel namun ketika ditampilkan malah not responding munculnya aga lama kira-kira penyebabnya apa ya ?terima kasih
Wasalammualaikum Wr. Wb.


#yiv2958979301 #yiv2958979301 -- #yiv2958979301ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2958979301 #yiv2958979301ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2958979301 #yiv2958979301ygrp-mkp #yiv2958979301hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2958979301 #yiv2958979301ygrp-mkp #yiv2958979301ads {margin-bottom:10px;}#yiv2958979301 #yiv2958979301ygrp-mkp .yiv2958979301ad {padding:0 0;}#yiv2958979301 #yiv2958979301ygrp-mkp .yiv2958979301ad p {margin:0;}#yiv2958979301 #yiv2958979301ygrp-mkp .yiv2958979301ad a {color:#0000ff;text-decoration:none;}#yiv2958979301 #yiv2958979301ygrp-sponsor #yiv2958979301ygrp-lc {font-family:Arial;}#yiv2958979301 #yiv2958979301ygrp-sponsor #yiv2958979301ygrp-lc #yiv2958979301hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2958979301 #yiv2958979301ygrp-sponsor #yiv2958979301ygrp-lc .yiv2958979301ad {margin-bottom:10px;padding:0 0;}#yiv2958979301 #yiv2958979301actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2958979301 #yiv2958979301activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2958979301 #yiv2958979301activity span {font-weight:700;}#yiv2958979301 #yiv2958979301activity span:first-child {text-transform:uppercase;}#yiv2958979301 #yiv2958979301activity span a {color:#5085b6;text-decoration:none;}#yiv2958979301 #yiv2958979301activity span span {color:#ff7900;}#yiv2958979301 #yiv2958979301activity span .yiv2958979301underline {text-decoration:underline;}#yiv2958979301 .yiv2958979301attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2958979301 .yiv2958979301attach div a {text-decoration:none;}#yiv2958979301 .yiv2958979301attach img {border:none;padding-right:5px;}#yiv2958979301 .yiv2958979301attach label {display:block;margin-bottom:5px;}#yiv2958979301 .yiv2958979301attach label a {text-decoration:none;}#yiv2958979301 blockquote {margin:0 0 0 4px;}#yiv2958979301 .yiv2958979301bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2958979301 .yiv2958979301bold a {text-decoration:none;}#yiv2958979301 dd.yiv2958979301last p a {font-family:Verdana;font-weight:700;}#yiv2958979301 dd.yiv2958979301last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2958979301 dd.yiv2958979301last p span.yiv2958979301yshortcuts {margin-right:0;}#yiv2958979301 div.yiv2958979301attach-table div div a {text-decoration:none;}#yiv2958979301 div.yiv2958979301attach-table {width:400px;}#yiv2958979301 div.yiv2958979301file-title a, #yiv2958979301 div.yiv2958979301file-title a:active, #yiv2958979301 div.yiv2958979301file-title a:hover, #yiv2958979301 div.yiv2958979301file-title a:visited {text-decoration:none;}#yiv2958979301 div.yiv2958979301photo-title a, #yiv2958979301 div.yiv2958979301photo-title a:active, #yiv2958979301 div.yiv2958979301photo-title a:hover, #yiv2958979301 div.yiv2958979301photo-title a:visited {text-decoration:none;}#yiv2958979301 div#yiv2958979301ygrp-mlmsg #yiv2958979301ygrp-msg p a span.yiv2958979301yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2958979301 .yiv2958979301green {color:#628c2a;}#yiv2958979301 .yiv2958979301MsoNormal {margin:0 0 0 0;}#yiv2958979301 o {font-size:0;}#yiv2958979301 #yiv2958979301photos div {float:left;width:72px;}#yiv2958979301 #yiv2958979301photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv2958979301 #yiv2958979301photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2958979301 #yiv2958979301reco-category {font-size:77%;}#yiv2958979301 #yiv2958979301reco-desc {font-size:77%;}#yiv2958979301 .yiv2958979301replbq {margin:4px;}#yiv2958979301 #yiv2958979301ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2958979301 #yiv2958979301ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2958979301 #yiv2958979301ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2958979301 #yiv2958979301ygrp-mlmsg select, #yiv2958979301 input, #yiv2958979301 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2958979301 #yiv2958979301ygrp-mlmsg pre, #yiv2958979301 code {font:115% monospace;}#yiv2958979301 #yiv2958979301ygrp-mlmsg * {line-height:1.22em;}#yiv2958979301 #yiv2958979301ygrp-mlmsg #yiv2958979301logo {padding-bottom:10px;}#yiv2958979301 #yiv2958979301ygrp-msg p a {font-family:Verdana;}#yiv2958979301 #yiv2958979301ygrp-msg p#yiv2958979301attach-count span {color:#1E66AE;font-weight:700;}#yiv2958979301 #yiv2958979301ygrp-reco #yiv2958979301reco-head {color:#ff7900;font-weight:700;}#yiv2958979301 #yiv2958979301ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2958979301 #yiv2958979301ygrp-sponsor #yiv2958979301ov li a {font-size:130%;text-decoration:none;}#yiv2958979301 #yiv2958979301ygrp-sponsor #yiv2958979301ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2958979301 #yiv2958979301ygrp-sponsor #yiv2958979301ov ul {margin:0;padding:0 0 0 8px;}#yiv2958979301 #yiv2958979301ygrp-text {font-family:Georgia;}#yiv2958979301 #yiv2958979301ygrp-text p {margin:0 0 1em 0;}#yiv2958979301 #yiv2958979301ygrp-text tt {font-size:120%;}#yiv2958979301 #yiv2958979301ygrp-vital ul li:last-child {border-right:none !important;}#yiv2958979301

Thu Jan 7, 2016 12:02 am (PST) . Posted by:

"Mr. Kid" nmkid.family@ymail.com

Coba diikuti baris prosesnya satu per satu. Nanti bisa tampak seberapa
banyak proses yang dilakukan.
Biasanya, hal seperti ini disebabkan karena ada proses berulang yang harus
dikerjakan.
Contoh :
di userform event init ada proses loop untuk mengisi sebuah combobox atau
listbox dengan proses loop.
eh... baru loop item pertama, event change si combobox atau listbox
bekerja, jadinya mengerjakan event change si combobox atau listbox dulu.
ndilalahnya, di event change si combo atau listbox ada proses mengisi
sebuah textbox....
lah apesnya, si textbox yang diisi punya event change yang kerjanya ngecek
apakah isinya begini begitu yang cukup panjang, disertai cek control
lainnya dan sebagainya...
terus menerus seperti itu sampai seluruh event selesai dikerjakan, baru
kembali lagi sedikit demi sedikit dan sampai di init lagi untuk mengerjakan
item loop ke-2. Di item loop ke-2 juga terjadi begitu... Kalau ada 1000
item yang diloop, maka jadilah ada kesan not responding.

Jadi, silakan dilacak dengan sabar setiap baris kodenya... Kalau kodenya
hasil copas, pelajari maksud SETIAP baris kode yang di-copas dan kemudian
baru dilacak berdasar maksud baris kode tersebut.

Akan bijak jika ada permasalahan, berusaha mencari masalah pada diri
sendiri lebih dulu sebelum menduga ada masalah dipihak lain, apalagi pihak
lain tersebut adalah sebuah komputer yang pasif, yang bekerja megikuti
perintah saja... Bukankah artinya kalau komputer bekerja lemot disebabkan
karena pemberi perintahnya memberi tugas yang lemot ?

gitu kan ya...

Wassalam,
Kid

On Thu, Jan 7, 2016 at 2:32 PM, imam cahyo yuwono chyywn@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:

>
>
> terima kasih sebelumnya sudah saya coba namun tetap tidak ada perubahan
> mungkin comp nya ya.. di task manager performa CPU meningkat ketika user
> form di munculkan setelah tampilan ada turun lagi
>
> terima kasih pa Iman nambah referensi saya ....
>
>
> On Thursday, January 7, 2016 10:40 AM, "Iman Darusman idz.iman@yahoo.com
> [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:
>
>
>
> Dear Pak Imam.
>
> Pengalaman saya, itu karena autosave nya aktif. coba saja di non aktifkan
> dengan cara :
>
> file => Option => save => unchecklist pada "save auto recover"
>
> semoga info ini membantu
>
>
> salam
> Iman DZ
>
>
> Pada Kamis, 7 Januari 2016 10:36, "imam cahyo yuwono chyywn@yahoo.com
> [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
>
>
>
> Assalamualaikaum Wr. Wb.
> Dear para master saya membuat user form dai excel namun ketika ditampilkan
> malah not responding munculnya aga lama kira-kira penyebabnya apa ya ?
> terima kasih
>
> Wasalammualaikum Wr. Wb.
>
>
>
>
>
>

Thu Jan 7, 2016 1:23 am (PST) . Posted by:

"Subroto, Matzen"

Assalamu alaikum Wr. Wb.

Dear Master

Mohon pencerahannya dengan kasus yang saya hadapi, formula dengan conditional formating

Terima kasih atas perhatian dan kerjasamanya, dan saya mohon maaf apabila ada kata-kata yang kurang berkenan

Terima Kasih
Wassalam

Matzen

============================================================
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:

Poskan Komentar