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' mr.nm...@gmail.com [belajar-excel]
<belajar-excel@yahoogroups.com> wrote:
Subject: Re: [belajar-excel] Warning BOX [1 Attachment]
To: "BeExcel" <belajar-excel@yahoogroups.com>
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' taleng...@gmail.com
[belajar-excel] <belajar-excel@yahoogroups.com>:
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
re-Warning BOX.xlsx
Description: MS-Excel 2007 spreadsheet
