[belajar-excel] combobox input data [1 Attachment]

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

[belajar-excel] combobox input data [1 Attachment]

HAIRUL ALAM
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

AssalamualaikumHairul Alam

=?UTF-8?b?Y29tYm9ib3ggaW5wdXQgZGF0YS54bHNt?= (70K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] combobox input data

Agus-2
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 [hidden email] [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
>
>


Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] combobox input data

HAIRUL ALAM
 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 [hidden email] [belajar-excel] <[hidden email]> 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 [hidden email] [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