Terimakasih Mas Nang Agus Benar sekali yang dimaksud Maaf Para Master, Maklum saya masih belajar macro Terimakasih Banyak Assalamualaikum Pada Kamis, 8 Agustus 2019 23.40.29 WIB, Agus nanga...@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:
Wa'alakumusalam waarahmatullah. Dear Hairul, coba di sheet4(MAIN) diketik cekript berikut: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$B$3" Then If Range("B3") = "PANJANG" Then Panjang If Range("B3") = "JUMLAH" Then IsiRumus End If End Sub Wasalamu'alaikum warahmatullah... Regard NangAgus On 8/7/2019 17:39, HAIRUL ALAM ha_m...@yahoo.co.id [belajar-excel] wrote: Salam para Master data combobox terlampir, seperti apa code macro bila sheets MAIN cell B3 dipilih JUMLAH Maka akan menghitung data pada sheet OUTPUT dan jika combobox sheets MAIN cell B3 dipilih PANJANG maka akan menghitung data pada sheet OUTPUTlength Assalamualaikum Hairul Alam #yiv4723985385 #yiv4723985385 -- #yiv4723985385ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4723985385 #yiv4723985385ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4723985385 #yiv4723985385ygrp-mkp #yiv4723985385hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4723985385 #yiv4723985385ygrp-mkp #yiv4723985385ads {margin-bottom:10px;}#yiv4723985385 #yiv4723985385ygrp-mkp .yiv4723985385ad {padding:0 0;}#yiv4723985385 #yiv4723985385ygrp-mkp .yiv4723985385ad p {margin:0;}#yiv4723985385 #yiv4723985385ygrp-mkp .yiv4723985385ad a {color:#0000ff;text-decoration:none;}#yiv4723985385 #yiv4723985385ygrp-sponsor #yiv4723985385ygrp-lc {font-family:Arial;}#yiv4723985385 #yiv4723985385ygrp-sponsor #yiv4723985385ygrp-lc #yiv4723985385hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4723985385 #yiv4723985385ygrp-sponsor #yiv4723985385ygrp-lc .yiv4723985385ad {margin-bottom:10px;padding:0 0;}#yiv4723985385 #yiv4723985385actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4723985385 #yiv4723985385activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4723985385 #yiv4723985385activity span {font-weight:700;}#yiv4723985385 #yiv4723985385activity span:first-child {text-transform:uppercase;}#yiv4723985385 #yiv4723985385activity span a {color:#5085b6;text-decoration:none;}#yiv4723985385 #yiv4723985385activity span span {color:#ff7900;}#yiv4723985385 #yiv4723985385activity span .yiv4723985385underline {text-decoration:underline;}#yiv4723985385 .yiv4723985385attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4723985385 .yiv4723985385attach div a {text-decoration:none;}#yiv4723985385 .yiv4723985385attach img {border:none;padding-right:5px;}#yiv4723985385 .yiv4723985385attach label {display:block;margin-bottom:5px;}#yiv4723985385 .yiv4723985385attach label a {text-decoration:none;}#yiv4723985385 blockquote {margin:0 0 0 4px;}#yiv4723985385 .yiv4723985385bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4723985385 .yiv4723985385bold a {text-decoration:none;}#yiv4723985385 dd.yiv4723985385last p a {font-family:Verdana;font-weight:700;}#yiv4723985385 dd.yiv4723985385last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4723985385 dd.yiv4723985385last p span.yiv4723985385yshortcuts {margin-right:0;}#yiv4723985385 div.yiv4723985385attach-table div div a {text-decoration:none;}#yiv4723985385 div.yiv4723985385attach-table {width:400px;}#yiv4723985385 div.yiv4723985385file-title a, #yiv4723985385 div.yiv4723985385file-title a:active, #yiv4723985385 div.yiv4723985385file-title a:hover, #yiv4723985385 div...yiv4723985385file-title a:visited {text-decoration:none;}#yiv4723985385 div.yiv4723985385photo-title a, #yiv4723985385 div.yiv4723985385photo-title a:active, #yiv4723985385 div.yiv4723985385photo-title a:hover, #yiv4723985385 div.yiv4723985385photo-title a:visited {text-decoration:none;}#yiv4723985385 div#yiv4723985385ygrp-mlmsg #yiv4723985385ygrp-msg p a span.yiv4723985385yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4723985385 .yiv4723985385green {color:#628c2a;}#yiv4723985385 .yiv4723985385MsoNormal {margin:0 0 0 0;}#yiv4723985385 o {font-size:0;}#yiv4723985385 #yiv4723985385photos div {float:left;width:72px;}#yiv4723985385 #yiv4723985385photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv4723985385 #yiv4723985385photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4723985385 #yiv4723985385reco-category {font-size:77%;}#yiv4723985385 #yiv4723985385reco-desc {font-size:77%;}#yiv4723985385 .yiv4723985385replbq {margin:4px;}#yiv4723985385 #yiv4723985385ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4723985385 #yiv4723985385ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4723985385 #yiv4723985385ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4723985385 #yiv4723985385ygrp-mlmsg select, #yiv4723985385 input, #yiv4723985385 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4723985385 #yiv4723985385ygrp-mlmsg pre, #yiv4723985385 code {font:115% monospace;}#yiv4723985385 #yiv4723985385ygrp-mlmsg * {line-height:1.22em;}#yiv4723985385 #yiv4723985385ygrp-mlmsg #yiv4723985385logo {padding-bottom:10px;}#yiv4723985385 #yiv4723985385ygrp-msg p a {font-family:Verdana;}#yiv4723985385 #yiv4723985385ygrp-msg p#yiv4723985385attach-count span {color:#1E66AE;font-weight:700;}#yiv4723985385 #yiv4723985385ygrp-reco #yiv4723985385reco-head {color:#ff7900;font-weight:700;}#yiv4723985385 #yiv4723985385ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4723985385 #yiv4723985385ygrp-sponsor #yiv4723985385ov li a {font-size:130%;text-decoration:none;}#yiv4723985385 #yiv4723985385ygrp-sponsor #yiv4723985385ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4723985385 #yiv4723985385ygrp-sponsor #yiv4723985385ov ul {margin:0;padding:0 0 0 8px;}#yiv4723985385 #yiv4723985385ygrp-text {font-family:Georgia;}#yiv4723985385 #yiv4723985385ygrp-text p {margin:0 0 1em 0;}#yiv4723985385 #yiv4723985385ygrp-text tt {font-size:120%;}#yiv4723985385 #yiv4723985385ygrp-vital ul li:last-child {border-right:none !important;}#yiv4723985385