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 [email protected]
[belajar-excel] <[email protected]> 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 [email protected] [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
