terimakasih mrtobi atas pencerahanya,,
Pada Kamis, 27 Agustus 2015 0:30, "Toby kenzo tobyke...@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis: | Dear Didon,Pada inti sama,yg membedakan hanya menggunakan userform. Jika kamu memahami konsep kaidah database,kamu bisa buat dalam bentuk apapun yg diinginkan,mungkin sedikit usaha dan kerja keras untuk lebih memahami VBA kmu bisa create sendiri tanpa meniru milik siapapun.TerimaKasih.Sent from Yahoo Mail on Android | From: achmad adi dido...@ymail.com [belajar-excel] <belajar-excel@yahoogroups.com>; To: <belajar-excel@yahoogroups.com>; Subject: Bls: [belajar-excel] valdasi bertingkat modif [1 Attachment] Sent: Mon, Aug 24, 2015 7:14:57 AM | terimakasih Mr toby..sebelumnyatapi sepertinya terlalu banayk perintah ya,,hehehehe...maksd q bisa gk dibuat yan lebih simple,,biar bisa belajar rumusnya.. seperti ini ni,,nemu di file milis punya Alm Bu siti dan saya kembangkan,,mentok,,untuk keterangan namanya,,mohon bantuanya Pada Senin, 24 Agustus 2015 0:25, "Toby kenzo tobyke...@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis: | Dear Didon,File berikut menggunakan VBA untuk valudasi bertingkat dngan menggunakan ComboBox.Semoga bisa membantu. It's work in Office 2013. TerimaKasih.Sent from Yahoo Mail on Android | From: achmad adi dido...@ymail.com [belajar-excel] <belajar-excel@yahoogroups.com>; To: <belajar-excel@yahoogroups.com>; Subject: [belajar-excel] valdasi bertingkat modif [1 Attachment] Sent: Thu, Aug 20, 2015 3:00:27 AM | dear master,,mohon bantuanyautnuk masalah yang saya hadapi,,mengambil dari validasi bertingkat di file mail archive BE,,,saya mau memodifikasi perintah masalah validasi bertingkat,,mohon pencerahaannya,,,ini saya lampirkan file contohnya.. sebelumnya saya ucapkan terima kasih | | #yiv3238179438 #yiv3238179438 -- #yiv3238179438ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3238179438 #yiv3238179438ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3238179438 #yiv3238179438ygrp-mkp #yiv3238179438hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3238179438 #yiv3238179438ygrp-mkp #yiv3238179438ads {margin-bottom:10px;}#yiv3238179438 #yiv3238179438ygrp-mkp .yiv3238179438ad {padding:0 0;}#yiv3238179438 #yiv3238179438ygrp-mkp .yiv3238179438ad p {margin:0;}#yiv3238179438 #yiv3238179438ygrp-mkp .yiv3238179438ad a {color:#0000ff;text-decoration:none;}#yiv3238179438 #yiv3238179438ygrp-sponsor #yiv3238179438ygrp-lc {font-family:Arial;}#yiv3238179438 #yiv3238179438ygrp-sponsor #yiv3238179438ygrp-lc #yiv3238179438hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3238179438 #yiv3238179438ygrp-sponsor #yiv3238179438ygrp-lc .yiv3238179438ad {margin-bottom:10px;padding:0 0;}#yiv3238179438 #yiv3238179438actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3238179438 #yiv3238179438activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3238179438 #yiv3238179438activity span {font-weight:700;}#yiv3238179438 #yiv3238179438activity span:first-child {text-transform:uppercase;}#yiv3238179438 #yiv3238179438activity span a {color:#5085b6;text-decoration:none;}#yiv3238179438 #yiv3238179438activity span span {color:#ff7900;}#yiv3238179438 #yiv3238179438activity span .yiv3238179438underline {text-decoration:underline;}#yiv3238179438 .yiv3238179438attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3238179438 .yiv3238179438attach div a {text-decoration:none;}#yiv3238179438 .yiv3238179438attach img {border:none;padding-right:5px;}#yiv3238179438 .yiv3238179438attach label {display:block;margin-bottom:5px;}#yiv3238179438 .yiv3238179438attach label a {text-decoration:none;}#yiv3238179438 blockquote {margin:0 0 0 4px;}#yiv3238179438 .yiv3238179438bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3238179438 .yiv3238179438bold a {text-decoration:none;}#yiv3238179438 dd.yiv3238179438last p a {font-family:Verdana;font-weight:700;}#yiv3238179438 dd.yiv3238179438last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3238179438 dd.yiv3238179438last p span.yiv3238179438yshortcuts {margin-right:0;}#yiv3238179438 div.yiv3238179438attach-table div div a {text-decoration:none;}#yiv3238179438 div.yiv3238179438attach-table {width:400px;}#yiv3238179438 div.yiv3238179438file-title a, #yiv3238179438 div.yiv3238179438file-title a:active, #yiv3238179438 div.yiv3238179438file-title a:hover, #yiv3238179438 div.yiv3238179438file-title a:visited {text-decoration:none;}#yiv3238179438 div.yiv3238179438photo-title a, #yiv3238179438 div.yiv3238179438photo-title a:active, #yiv3238179438 div.yiv3238179438photo-title a:hover, #yiv3238179438 div.yiv3238179438photo-title a:visited {text-decoration:none;}#yiv3238179438 div#yiv3238179438ygrp-mlmsg #yiv3238179438ygrp-msg p a span.yiv3238179438yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3238179438 .yiv3238179438green {color:#628c2a;}#yiv3238179438 .yiv3238179438MsoNormal {margin:0 0 0 0;}#yiv3238179438 o {font-size:0;}#yiv3238179438 #yiv3238179438photos div {float:left;width:72px;}#yiv3238179438 #yiv3238179438photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv3238179438 #yiv3238179438photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3238179438 #yiv3238179438reco-category {font-size:77%;}#yiv3238179438 #yiv3238179438reco-desc {font-size:77%;}#yiv3238179438 .yiv3238179438replbq {margin:4px;}#yiv3238179438 #yiv3238179438ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3238179438 #yiv3238179438ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3238179438 #yiv3238179438ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3238179438 #yiv3238179438ygrp-mlmsg select, #yiv3238179438 input, #yiv3238179438 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3238179438 #yiv3238179438ygrp-mlmsg pre, #yiv3238179438 code {font:115% monospace;}#yiv3238179438 #yiv3238179438ygrp-mlmsg * {line-height:1.22em;}#yiv3238179438 #yiv3238179438ygrp-mlmsg #yiv3238179438logo {padding-bottom:10px;}#yiv3238179438 #yiv3238179438ygrp-msg p a {font-family:Verdana;}#yiv3238179438 #yiv3238179438ygrp-msg p#yiv3238179438attach-count span {color:#1E66AE;font-weight:700;}#yiv3238179438 #yiv3238179438ygrp-reco #yiv3238179438reco-head {color:#ff7900;font-weight:700;}#yiv3238179438 #yiv3238179438ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3238179438 #yiv3238179438ygrp-sponsor #yiv3238179438ov li a {font-size:130%;text-decoration:none;}#yiv3238179438 #yiv3238179438ygrp-sponsor #yiv3238179438ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3238179438 #yiv3238179438ygrp-sponsor #yiv3238179438ov ul {margin:0;padding:0 0 0 8px;}#yiv3238179438 #yiv3238179438ygrp-text {font-family:Georgia;}#yiv3238179438 #yiv3238179438ygrp-text p {margin:0 0 1em 0;}#yiv3238179438 #yiv3238179438ygrp-text tt {font-size:120%;}#yiv3238179438 #yiv3238179438ygrp-vital ul li:last-child {border-right:none !important;}#yiv3238179438