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