Terima Kasih Mr. Kid On Thu, Jun 11, 2015 at 6:26 PM, 'Mr. Kid' [email protected] [belajar-excel] <[email protected]> wrote:
> > > Yup... > > Data validation dipasang diarea inputan user, bukan di range berformula. > Kalau user menginput di kolom A dan B, sedang C berisi formula menjumlah A > dan B, maka yang diberi data validation adalah kolom A dan B nya. > > File dilampirkan lagi. Coba cek di inbox atau spam pada akun email yang > Anda gunakan ([email protected]) atau lihat di arsip milis di : > > https://groups.yahoo.com/neo/groups/belajar-excel/conversations/messages/37094 > > Wassalam, > Kid > > > > > > > > > > On Thu, Jun 11, 2015 at 8:16 PM, 'Roy@ld' [email protected] > [belajar-excel] <[email protected]> wrote: > >> >> >> maaf suhu Kid >> >> maksudnya untuk data yang berisi formula tidak bisa dibuat data >> validation..? >> >> sengaja saya membuat warning box, agar saat menginput sang user bisa >> mengetahui bahwa hasil yang diinput tidak sesuai ketentuan, dan ini sangat >> berpengaruh pada pengambilan keputusan akhir. >> dimana selama ini sang user sering kali melewatkan pesan yang saya buat >> manual menggunakan fungsi IF >> >> >> saya sdh coba data validation namun hanya untuk data/kolom yang diinput >> saja, bukan hasil inputan >> >> maaf suhu Kid file yang dilampirkan saya tidak terima >> apa tertinggal atau bagaimana yaa >> >> jika data validation tidak bisa mengakomodir bagaimana dengan makro... >> >> terima kasih sebelumnya dan mohon maaf merepotkan. >> >> salam >> Roy >> >> On Thu, Jun 11, 2015 at 5:51 PM, 'Mr. Kid' [email protected] >> [belajar-excel] <[email protected]> wrote: >> >>> >>> >>> Yang diberi data validation adalah range yang menjadi area entry data >>> alias yang dirujuk oleh formula dan bukan range yang berisi formula. >>> >>> >>> On Thu, Jun 11, 2015 at 7:29 PM, Danu Purboyo [email protected] >>> [belajar-excel] <[email protected]> wrote: >>> >>>> >>>> >>>> Kak Kid, >>>> >>>> Saya coba sendiri sesuai dengan petunjuk di File pake Data Validation >>>> kok gagal yha? >>>> Salah dimana kah.. >>>> >>>> Thx >>>> Dn >>>> >>>> -------------------------------------------- >>>> On Thu, 6/11/15, 'Mr. Kid' [email protected] [belajar-excel] < >>>> [email protected]> wrote: >>>> >>>> Subject: Re: [belajar-excel] Warning BOX [1 Attachment] >>>> To: "BeExcel" <[email protected]> >>>> Date: Thursday, June 11, 2015, 1:46 PM >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> Hai >>>> Roy, >>>> >>>> File terlampir >>>> dengan fitur Data Validation. >>>> Syarat >>>> dan ketentuan berlaku. >>>> >>>> Jika isian sesuai ketentuan tapi tetap >>>> menampilkan warning box, malah jadinya mengganggu yang >>>> sedang entry data karena harus klik tombol (beralih dari >>>> fokus peng-entry-an data ke warning box untuk mencari tombol >>>> OK). >>>> >>>> imho, >>>> warning box muncul saat entry yang tidak >>>> sesuai ketentuan saja. >>>> Pernah >>>> ketemukah bahwa pengisian suatu form dengan komputer kalau >>>> benar mengisinya muncul suatu kotak pesan ? >>>> >>>> Wassalam, >>>> Kid >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> 2015-06-11 16:16 GMT+10:00 >>>> 'Roy@ld' [email protected] >>>> [belajar-excel] <[email protected]>: >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> Yth : >>>> Para Suhu Excel >>>> >>>> mohon bantuannya terkait kesulitan saya >>>> sebagaimana dibawah ini : >>>> >>>> >>>> 1. 47 + 4 >>>> = 51 (jika dari hasil penjumlahan diatas 50 maka akan >>>> muncul Warning Box dengan keterangan Umur Melebihi >>>> ketentuan) >>>> >>>> 2. 45 >>>> + 2 = 47 (jika dari hasil penjumlahan dibawah 50 maka >>>> akan muncul Warning Box dengan keterangan Silakan >>>> Dilanjutkan) >>>> >>>> >>>> kalau bisa tanpa menggunakan makro >>>> namun jika harus menggunakan makro tidak >>>> masalah, selama dibantu step by step makronya >>>> >>>> untuk lebih >>>> jelasnya seperti file terlampir >>>> >>>> Terima kasih >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> #yiv0871706805 #yiv0871706805 -- >>>> #yiv0871706805ygrp-mkp { >>>> border:1px solid #d8d8d8;font-family:Arial;margin:10px >>>> 0;padding:0 10px;} >>>> >>>> #yiv0871706805 #yiv0871706805ygrp-mkp hr { >>>> border:1px solid #d8d8d8;} >>>> >>>> #yiv0871706805 #yiv0871706805ygrp-mkp #yiv0871706805hd { >>>> color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px >>>> 0;} >>>> >>>> #yiv0871706805 #yiv0871706805ygrp-mkp #yiv0871706805ads { >>>> margin-bottom:10px;} >>>> >>>> #yiv0871706805 #yiv0871706805ygrp-mkp .yiv0871706805ad { >>>> padding:0 0;} >>>> >>>> #yiv0871706805 #yiv0871706805ygrp-mkp .yiv0871706805ad p { >>>> margin:0;} >>>> >>>> #yiv0871706805 #yiv0871706805ygrp-mkp .yiv0871706805ad a { >>>> color:#0000ff;text-decoration:none;} >>>> #yiv0871706805 #yiv0871706805ygrp-sponsor >>>> #yiv0871706805ygrp-lc { >>>> font-family:Arial;} >>>> >>>> #yiv0871706805 #yiv0871706805ygrp-sponsor >>>> #yiv0871706805ygrp-lc #yiv0871706805hd { >>>> margin:10px >>>> 0px;font-weight:700;font-size:78%;line-height:122%;} >>>> >>>> #yiv0871706805 #yiv0871706805ygrp-sponsor >>>> #yiv0871706805ygrp-lc .yiv0871706805ad { >>>> margin-bottom:10px;padding:0 0;} >>>> >>>> #yiv0871706805 #yiv0871706805actions { >>>> font-family:Verdana;font-size:11px;padding:10px 0;} >>>> >>>> #yiv0871706805 #yiv0871706805activity { >>>> >>>> background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;} >>>> >>>> #yiv0871706805 #yiv0871706805activity span { >>>> font-weight:700;} >>>> >>>> #yiv0871706805 #yiv0871706805activity span:first-child { >>>> text-transform:uppercase;} >>>> >>>> #yiv0871706805 #yiv0871706805activity span a { >>>> color:#5085b6;text-decoration:none;} >>>> >>>> #yiv0871706805 #yiv0871706805activity span span { >>>> color:#ff7900;} >>>> >>>> #yiv0871706805 #yiv0871706805activity span >>>> .yiv0871706805underline { >>>> text-decoration:underline;} >>>> >>>> #yiv0871706805 .yiv0871706805attach { >>>> clear:both;display:table;font-family:Arial;font-size:12px;padding:10px >>>> 0;width:400px;} >>>> >>>> #yiv0871706805 .yiv0871706805attach div a { >>>> text-decoration:none;} >>>> >>>> #yiv0871706805 .yiv0871706805attach img { >>>> border:none;padding-right:5px;} >>>> >>>> >>>> #yiv0871706805 .yiv0871706805attach label { >>>> display:block;margin-bottom:5px;} >>>> >>>> #yiv0871706805 .yiv0871706805attach label a { >>>> text-decoration:none;} >>>> >>>> #yiv0871706805 blockquote { >>>> margin:0 0 0 4px;} >>>> >>>> #yiv0871706805 .yiv0871706805bold { >>>> font-family:Arial;font-size:13px;font-weight:700;} >>>> >>>> #yiv0871706805 .yiv0871706805bold a { >>>> text-decoration:none;} >>>> >>>> #yiv0871706805 dd.yiv0871706805last p a { >>>> font-family:Verdana;font-weight:700;} >>>> >>>> #yiv0871706805 dd.yiv0871706805last p span { >>>> margin-right:10px;font-family:Verdana;font-weight:700;} >>>> >>>> #yiv0871706805 dd.yiv0871706805last p >>>> span.yiv0871706805yshortcuts { >>>> margin-right:0;} >>>> >>>> #yiv0871706805 div.yiv0871706805attach-table div div a { >>>> text-decoration:none;} >>>> >>>> #yiv0871706805 div.yiv0871706805attach-table { >>>> width:400px;} >>>> >>>> #yiv0871706805 div.yiv0871706805file-title a, #yiv0871706805 >>>> div.yiv0871706805file-title a:active, #yiv0871706805 >>>> div.yiv0871706805file-title a:hover, #yiv0871706805 >>>> div.yiv0871706805file-title a:visited { >>>> text-decoration:none;} >>>> >>>> #yiv0871706805 div.yiv0871706805photo-title a, >>>> #yiv0871706805 div.yiv0871706805photo-title a:active, >>>> #yiv0871706805 div.yiv0871706805photo-title a:hover, >>>> #yiv0871706805 div.yiv0871706805photo-title a:visited { >>>> text-decoration:none;} >>>> >>>> #yiv0871706805 div#yiv0871706805ygrp-mlmsg >>>> #yiv0871706805ygrp-msg p a span.yiv0871706805yshortcuts { >>>> font-family:Verdana;font-size:10px;font-weight:normal;} >>>> >>>> #yiv0871706805 .yiv0871706805green { >>>> color:#628c2a;} >>>> >>>> #yiv0871706805 .yiv0871706805MsoNormal { >>>> margin:0 0 0 0;} >>>> >>>> #yiv0871706805 o { >>>> font-size:0;} >>>> >>>> #yiv0871706805 #yiv0871706805photos div { >>>> float:left;width:72px;} >>>> >>>> #yiv0871706805 #yiv0871706805photos div div { >>>> border:1px solid >>>> #666666;height:62px;overflow:hidden;width:62px;} >>>> >>>> #yiv0871706805 #yiv0871706805photos div label { >>>> >>>> color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;} >>>> >>>> #yiv0871706805 #yiv0871706805reco-category { >>>> font-size:77%;} >>>> >>>> #yiv0871706805 #yiv0871706805reco-desc { >>>> font-size:77%;} >>>> >>>> #yiv0871706805 .yiv0871706805replbq { >>>> margin:4px;} >>>> >>>> >>>> #yiv0871706805 #yiv0871706805ygrp-actbar div a:first-child { >>>> margin-right:2px;padding-right:5px;} >>>> >>>> #yiv0871706805 #yiv0871706805ygrp-mlmsg { >>>> font-size:13px;font-family:Arial, helvetica, clean, >>>> sans-serif;} >>>> >>>> #yiv0871706805 #yiv0871706805ygrp-mlmsg table { >>>> font-size:inherit;font:100%;} >>>> >>>> #yiv0871706805 #yiv0871706805ygrp-mlmsg select, >>>> #yiv0871706805 input, #yiv0871706805 textarea { >>>> font:99% Arial, Helvetica, clean, sans-serif;} >>>> >>>> #yiv0871706805 #yiv0871706805ygrp-mlmsg pre, #yiv0871706805 >>>> code { >>>> font:115% monospace;} >>>> >>>> #yiv0871706805 #yiv0871706805ygrp-mlmsg * { >>>> line-height:1.22em;} >>>> >>>> #yiv0871706805 #yiv0871706805ygrp-mlmsg #yiv0871706805logo { >>>> padding-bottom:10px;} >>>> >>>> >>>> #yiv0871706805 #yiv0871706805ygrp-msg p a { >>>> font-family:Verdana;} >>>> >>>> #yiv0871706805 #yiv0871706805ygrp-msg >>>> p#yiv0871706805attach-count span { >>>> color:#1E66AE;font-weight:700;} >>>> >>>> #yiv0871706805 #yiv0871706805ygrp-reco >>>> #yiv0871706805reco-head { >>>> color:#ff7900;font-weight:700;} >>>> >>>> #yiv0871706805 #yiv0871706805ygrp-reco { >>>> margin-bottom:20px;padding:0px;} >>>> >>>> #yiv0871706805 #yiv0871706805ygrp-sponsor #yiv0871706805ov >>>> li a { >>>> font-size:130%;text-decoration:none;} >>>> >>>> #yiv0871706805 #yiv0871706805ygrp-sponsor #yiv0871706805ov >>>> li { >>>> font-size:77%;list-style-type:square;padding:6px 0;} >>>> >>>> #yiv0871706805 #yiv0871706805ygrp-sponsor #yiv0871706805ov >>>> ul { >>>> margin:0;padding:0 0 0 8px;} >>>> >>>> #yiv0871706805 #yiv0871706805ygrp-text { >>>> font-family:Georgia;} >>>> >>>> #yiv0871706805 #yiv0871706805ygrp-text p { >>>> margin:0 0 1em 0;} >>>> >>>> #yiv0871706805 #yiv0871706805ygrp-text tt { >>>> font-size:120%;} >>>> >>>> #yiv0871706805 #yiv0871706805ygrp-vital ul li:last-child { >>>> border-right:none !important; >>>> } >>>> #yiv0871706805 >>>> >>>> >>> >> > >
