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 | #yiv6913246463 #yiv6913246463 -- #yiv6913246463ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6913246463 #yiv6913246463ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6913246463 #yiv6913246463ygrp-mkp #yiv6913246463hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6913246463 #yiv6913246463ygrp-mkp #yiv6913246463ads {margin-bottom:10px;}#yiv6913246463 #yiv6913246463ygrp-mkp .yiv6913246463ad {padding:0 0;}#yiv6913246463 #yiv6913246463ygrp-mkp .yiv6913246463ad p {margin:0;}#yiv6913246463 #yiv6913246463ygrp-mkp .yiv6913246463ad a {color:#0000ff;text-decoration:none;}#yiv6913246463 #yiv6913246463ygrp-sponsor #yiv6913246463ygrp-lc {font-family:Arial;}#yiv6913246463 #yiv6913246463ygrp-sponsor #yiv6913246463ygrp-lc #yiv6913246463hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6913246463 #yiv6913246463ygrp-sponsor #yiv6913246463ygrp-lc .yiv6913246463ad {margin-bottom:10px;padding:0 0;}#yiv6913246463 #yiv6913246463actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6913246463 #yiv6913246463activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6913246463 #yiv6913246463activity span {font-weight:700;}#yiv6913246463 #yiv6913246463activity span:first-child {text-transform:uppercase;}#yiv6913246463 #yiv6913246463activity span a {color:#5085b6;text-decoration:none;}#yiv6913246463 #yiv6913246463activity span span {color:#ff7900;}#yiv6913246463 #yiv6913246463activity span .yiv6913246463underline {text-decoration:underline;}#yiv6913246463 .yiv6913246463attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6913246463 .yiv6913246463attach div a {text-decoration:none;}#yiv6913246463 .yiv6913246463attach img {border:none;padding-right:5px;}#yiv6913246463 .yiv6913246463attach label {display:block;margin-bottom:5px;}#yiv6913246463 .yiv6913246463attach label a {text-decoration:none;}#yiv6913246463 blockquote {margin:0 0 0 4px;}#yiv6913246463 .yiv6913246463bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6913246463 .yiv6913246463bold a {text-decoration:none;}#yiv6913246463 dd.yiv6913246463last p a {font-family:Verdana;font-weight:700;}#yiv6913246463 dd.yiv6913246463last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6913246463 dd.yiv6913246463last p span.yiv6913246463yshortcuts {margin-right:0;}#yiv6913246463 div.yiv6913246463attach-table div div a {text-decoration:none;}#yiv6913246463 div.yiv6913246463attach-table {width:400px;}#yiv6913246463 div.yiv6913246463file-title a, #yiv6913246463 div.yiv6913246463file-title a:active, #yiv6913246463 div.yiv6913246463file-title a:hover, #yiv6913246463 div.yiv6913246463file-title a:visited {text-decoration:none;}#yiv6913246463 div.yiv6913246463photo-title a, #yiv6913246463 div.yiv6913246463photo-title a:active, #yiv6913246463 div.yiv6913246463photo-title a:hover, #yiv6913246463 div.yiv6913246463photo-title a:visited {text-decoration:none;}#yiv6913246463 div#yiv6913246463ygrp-mlmsg #yiv6913246463ygrp-msg p a span.yiv6913246463yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6913246463 .yiv6913246463green {color:#628c2a;}#yiv6913246463 .yiv6913246463MsoNormal {margin:0 0 0 0;}#yiv6913246463 o {font-size:0;}#yiv6913246463 #yiv6913246463photos div {float:left;width:72px;}#yiv6913246463 #yiv6913246463photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv6913246463 #yiv6913246463photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6913246463 #yiv6913246463reco-category {font-size:77%;}#yiv6913246463 #yiv6913246463reco-desc {font-size:77%;}#yiv6913246463 .yiv6913246463replbq {margin:4px;}#yiv6913246463 #yiv6913246463ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6913246463 #yiv6913246463ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6913246463 #yiv6913246463ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6913246463 #yiv6913246463ygrp-mlmsg select, #yiv6913246463 input, #yiv6913246463 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6913246463 #yiv6913246463ygrp-mlmsg pre, #yiv6913246463 code {font:115% monospace;}#yiv6913246463 #yiv6913246463ygrp-mlmsg * {line-height:1.22em;}#yiv6913246463 #yiv6913246463ygrp-mlmsg #yiv6913246463logo {padding-bottom:10px;}#yiv6913246463 #yiv6913246463ygrp-msg p a {font-family:Verdana;}#yiv6913246463 #yiv6913246463ygrp-msg p#yiv6913246463attach-count span {color:#1E66AE;font-weight:700;}#yiv6913246463 #yiv6913246463ygrp-reco #yiv6913246463reco-head {color:#ff7900;font-weight:700;}#yiv6913246463 #yiv6913246463ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6913246463 #yiv6913246463ygrp-sponsor #yiv6913246463ov li a {font-size:130%;text-decoration:none;}#yiv6913246463 #yiv6913246463ygrp-sponsor #yiv6913246463ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6913246463 #yiv6913246463ygrp-sponsor #yiv6913246463ov ul {margin:0;padding:0 0 0 8px;}#yiv6913246463 #yiv6913246463ygrp-text {font-family:Georgia;}#yiv6913246463 #yiv6913246463ygrp-text p {margin:0 0 1em 0;}#yiv6913246463 #yiv6913246463ygrp-text tt {font-size:120%;}#yiv6913246463 #yiv6913246463ygrp-vital ul li:last-child {border-right:none !important;}#yiv6913246463
Validasi MAKRO.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12