[belajar-excel] menampilkan data dengan memilih data dari List Box ActiveX Controls [2 Attachments]

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

[belajar-excel] menampilkan data dengan memilih data dari List Box ActiveX Controls [2 Attachments]

HAIRUL ALAM
Salam Member
Selamat Pagi
Semoga selalu dalam keadaan sehat
hendak membuat link data dari List Box ActiveX Controls Excel cuma belum dapat caranya.
seperti data terlampir



Mohon solusinya
Terimakasih
Assalamualaikum

link data List Box ActiveX Controls.xlsx (26K) Download Attachment
=?UTF-8?b?MTU3NDY1NjA0NDI5NWJsb2IuanBn?= (143K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

RE: [belajar-excel] menampilkan data dengan memilih data dari List Box ActiveX Controls

Contract Mining Assistant, Asam-Asam
Seperti terlampir kah maksudnya.
Source data mengacu pada column D.

Salam, Rasyid

From: [hidden email] [mailto:[hidden email]]
Sent: Monday, November 25, 2019 12:27 PM
To: [hidden email]
Subject: [belajar-excel] menampilkan data dengan memilih data dari List Box ActiveX Controls [2 Attachments]


Salam Member

Selamat Pagi

Semoga selalu dalam keadaan sehat

hendak membuat link data dari List Box ActiveX Controls Excel cuma belum dapat caranya.

seperti data terlampir

[Jadikan gambar sebaris]

Mohon solusinya

Terimakasih

Assalamualaikum

Disclaimer   -   This  message  including any attachments and information contained
herein  ("Message" ) may contain  privileged information  or otherwise is protected
from  disclosure. Any  unauthorized use of this  Message  by any person may lead to
legal consequences.  If  you  receive this   Message  in error, or if the recipient
of this  Message  is not the intended recipient or the employee or agent authorized
for delivering this  Message to the intended recipient you are hereby notified that
any  disclosure,  dissemination, distribution  or copying of this Message or let or
cause this Message to be disclosed,disseminated, distributed, or copied is strictly
prohibited, and please notify the sender by  return message  and immediately delete
this  Message  from your system.   Incoming and outgoing  communications using this
electronic mail may be monitored by PT Arutmin Indonesia,as permitted by applicable
law and regulations. Unless it is made by the authorized person,any views expressed
in this Message  are those of the individual sender and may not necessarily reflect
the views of PT Arutmin Indonesia.
You should check attachments for viruses and defects before opening or using them.
We are not liable to recover any injuries caused by virused or defected attachments.


image001.png (143K) Download Attachment
link data List Box ActiveX Controls.xlsx (31K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] menampilkan data dengan memilih data dari List Box ActiveX Controls [1 Attachment]

Sony Ario
In reply to this post by HAIRUL ALAM
Waalaikumsalaam.

Sambil tunggu yg lain. Ini dari saya.

Difile yang saya lampirkan listbox nya hanya ada 2. Maaf saya kurang paham
knp harus ada 6 ya.

Semoga membantu.

Wassalam



On Mon, Nov 25, 2019 at 2:30 PM HAIRUL ALAM [hidden email]
[belajar-excel] <[hidden email]> wrote:

>
>
> Salam Member
>
> Selamat Pagi
>
> Semoga selalu dalam keadaan sehat
>
> hendak membuat link data dari List Box ActiveX Controls Excel cuma belum
> dapat caranya.
>
> seperti data terlampir
>
> [image: Jadikan gambar sebaris]
>
>
> Mohon solusinya
>
> Terimakasih
>
> Assalamualaikum
>
>
>

1574656044295blob.jpg (143K) Download Attachment
ActiveXListBox.xlsm (32K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] menampilkan data dengan memilih data dari List Box ActiveX Controls [1 Attachment]

HAIRUL ALAM
 Terimakasih Mas Sony,
SalamHairul Alam
    Pada Senin, 25 November 2019 15...50.12 WIB, Sony Ario [hidden email] [belajar-excel] <[hidden email]> menulis:

  

Waalaikumsalaam.
Sambil tunggu yg lain. Ini dari saya.
Difile yang saya lampirkan listbox nya hanya ada 2. Maaf saya kurang paham knp harus ada 6 ya.
Semoga membantu.
Wassalam


On Mon, Nov 25, 2019 at 2:30 PM HAIRUL ALAM [hidden email] [belajar-excel] <[hidden email]> wrote:

  

Salam Member
Selamat Pagi
Semoga selalu dalam keadaan sehat
hendak membuat link data dari List Box ActiveX Controls Excel cuma belum dapat caranya.
seperti data terlampir



Mohon solusinya
Terimakasih
Assalamualaikum


  #yiv5474186159 #yiv5474186159 -- #yiv5474186159ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5474186159 #yiv5474186159ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5474186159 #yiv5474186159ygrp-mkp #yiv5474186159hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5474186159 #yiv5474186159ygrp-mkp #yiv5474186159ads {margin-bottom:10px;}#yiv5474186159 #yiv5474186159ygrp-mkp .yiv5474186159ad {padding:0 0;}#yiv5474186159 #yiv5474186159ygrp-mkp .yiv5474186159ad p {margin:0;}#yiv5474186159 #yiv5474186159ygrp-mkp .yiv5474186159ad a {color:#0000ff;text-decoration:none;}#yiv5474186159 #yiv5474186159ygrp-sponsor #yiv5474186159ygrp-lc {font-family:Arial;}#yiv5474186159 #yiv5474186159ygrp-sponsor #yiv5474186159ygrp-lc #yiv5474186159hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5474186159 #yiv5474186159ygrp-sponsor #yiv5474186159ygrp-lc .yiv5474186159ad {margin-bottom:10px;padding:0 0;}#yiv5474186159 #yiv5474186159actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5474186159 #yiv5474186159activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5474186159 #yiv5474186159activity span {font-weight:700;}#yiv5474186159 #yiv5474186159activity span:first-child {text-transform:uppercase;}#yiv5474186159 #yiv5474186159activity span a {color:#5085b6;text-decoration:none;}#yiv5474186159 #yiv5474186159activity span span {color:#ff7900;}#yiv5474186159 #yiv5474186159activity span .yiv5474186159underline {text-decoration:underline;}#yiv5474186159 ...yiv5474186159attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5474186159 .yiv5474186159attach div a {text-decoration:none;}#yiv5474186159 .yiv5474186159attach img {border:none;padding-right:5px;}#yiv5474186159 .yiv5474186159attach label {display:block;margin-bottom:5px;}#yiv5474186159 .yiv5474186159attach label a {text-decoration:none;}#yiv5474186159 blockquote {margin:0 0 0 4px;}#yiv5474186159 .yiv5474186159bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5474186159 .yiv5474186159bold a {text-decoration:none;}#yiv5474186159 dd.yiv5474186159last p a {font-family:Verdana;font-weight:700;}#yiv5474186159 dd.yiv5474186159last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5474186159 dd.yiv5474186159last p span.yiv5474186159yshortcuts {margin-right:0;}#yiv5474186159 div.yiv5474186159attach-table div div a {text-decoration:none;}#yiv5474186159 div.yiv5474186159attach-table {width:400px;}#yiv5474186159 div.yiv5474186159file-title a, #yiv5474186159 div.yiv5474186159file-title a:active, #yiv5474186159 div.yiv5474186159file-title a:hover, #yiv5474186159 div.yiv5474186159file-title a:visited {text-decoration:none;}#yiv5474186159 div.yiv5474186159photo-title a, #yiv5474186159 div.yiv5474186159photo-title a:active, #yiv5474186159 div.yiv5474186159photo-title a:hover, #yiv5474186159 div.yiv5474186159photo-title a:visited {text-decoration:none;}#yiv5474186159 div#yiv5474186159ygrp-mlmsg #yiv5474186159ygrp-msg p a span.yiv5474186159yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5474186159 .yiv5474186159green {color:#628c2a;}#yiv5474186159 .yiv5474186159MsoNormal {margin:0 0 0 0;}#yiv5474186159 o {font-size:0;}#yiv5474186159 #yiv5474186159photos div {float:left;width:72px;}#yiv5474186159 #yiv5474186159photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv5474186159 #yiv5474186159photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5474186159 #yiv5474186159reco-category {font-size:77%;}#yiv5474186159 #yiv5474186159reco-desc {font-size:77%;}#yiv5474186159 .yiv5474186159replbq {margin:4px;}#yiv5474186159 #yiv5474186159ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5474186159 #yiv5474186159ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5474186159 #yiv5474186159ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5474186159 #yiv5474186159ygrp-mlmsg select, #yiv5474186159 input, #yiv5474186159 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5474186159 #yiv5474186159ygrp-mlmsg pre, #yiv5474186159 code {font:115% monospace;}#yiv5474186159 #yiv5474186159ygrp-mlmsg * {line-height:1.22em;}#yiv5474186159 #yiv5474186159ygrp-mlmsg #yiv5474186159logo {padding-bottom:10px;}#yiv5474186159 #yiv5474186159ygrp-msg p a {font-family:Verdana;}#yiv5474186159 #yiv5474186159ygrp-msg p#yiv5474186159attach-count span {color:#1E66AE;font-weight:700;}#yiv5474186159 #yiv5474186159ygrp-reco #yiv5474186159reco-head {color:#ff7900;font-weight:700;}#yiv5474186159 #yiv5474186159ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5474186159 #yiv5474186159ygrp-sponsor #yiv5474186159ov li a {font-size:130%;text-decoration:none;}#yiv5474186159 #yiv5474186159ygrp-sponsor #yiv5474186159ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5474186159 #yiv5474186159ygrp-sponsor #yiv5474186159ov ul {margin:0;padding:0 0 0 8px;}#yiv5474186159 #yiv5474186159ygrp-text {font-family:Georgia;}#yiv5474186159 #yiv5474186159ygrp-text p {margin:0 0 1em 0;}#yiv5474186159 #yiv5474186159ygrp-text tt {font-size:120%;}#yiv5474186159 #yiv5474186159ygrp-vital ul li:last-child {border-right:none !important;}#yiv5474186159

1574656044295blob.jpg (143K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] menampilkan data dengan memilih data dari List Box ActiveX Controls

HAIRUL ALAM
 Salam Mas Sony
Kalau seperti terlampir seperti apa code macronya ya
Terimakasih
Assalamualaikum
    Pada Senin, 25 November 2019 18.49.21 WIB, HAIRUL ALAM <[hidden email]> menulis:

  Terimakasih Mas Sony,
SalamHairul Alam
    Pada Senin, 25 November 2019 15.50.12 WIB, Sony Ario [hidden email] [belajar-excel] <[hidden email]> menulis:

  

Waalaikumsalaam.
Sambil tunggu yg lain. Ini dari saya.
Difile yang saya lampirkan listbox nya hanya ada 2. Maaf saya kurang paham knp harus ada 6 ya.
Semoga membantu.
Wassalam


On Mon, Nov 25, 2019 at 2:30 PM HAIRUL ALAM [hidden email] [belajar-excel] <[hidden email]> wrote:

  

Salam Member
Selamat Pagi
Semoga selalu dalam keadaan sehat
hendak membuat link data dari List Box ActiveX Controls Excel cuma belum dapat caranya.
seperti data terlampir



Mohon solusinya
Terimakasih
Assalamualaikum


  #yiv7172624434 -- #yiv7172624434ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7172624434 #yiv7172624434ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7172624434 #yiv7172624434ygrp-mkp #yiv7172624434hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7172624434 #yiv7172624434ygrp-mkp #yiv7172624434ads {margin-bottom:10px;}#yiv7172624434 #yiv7172624434ygrp-mkp .yiv7172624434ad {padding:0 0;}#yiv7172624434 #yiv7172624434ygrp-mkp .yiv7172624434ad p {margin:0;}#yiv7172624434 #yiv7172624434ygrp-mkp .yiv7172624434ad a {color:#0000ff;text-decoration:none;}#yiv7172624434 #yiv7172624434ygrp-sponsor #yiv7172624434ygrp-lc {font-family:Arial;}#yiv7172624434 #yiv7172624434ygrp-sponsor #yiv7172624434ygrp-lc #yiv7172624434hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7172624434 #yiv7172624434ygrp-sponsor #yiv7172624434ygrp-lc .yiv7172624434ad {margin-bottom:10px;padding:0 0;}#yiv7172624434 #yiv7172624434actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7172624434 #yiv7172624434activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7172624434 #yiv7172624434activity span {font-weight:700;}#yiv7172624434 #yiv7172624434activity span:first-child {text-transform:uppercase;}#yiv7172624434 #yiv7172624434activity span a {color:#5085b6;text-decoration:none;}#yiv7172624434 #yiv7172624434activity span span {color:#ff7900;}#yiv7172624434 #yiv7172624434activity span .yiv7172624434underline {text-decoration:underline;}#yiv7172624434 .yiv7172624434attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7172624434 ...yiv7172624434attach div a {text-decoration:none;}#yiv7172624434 .yiv7172624434attach img {border:none;padding-right:5px;}#yiv7172624434 .yiv7172624434attach label {display:block;margin-bottom:5px;}#yiv7172624434 .yiv7172624434attach label a {text-decoration:none;}#yiv7172624434 blockquote {margin:0 0 0 4px;}#yiv7172624434 .yiv7172624434bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7172624434 .yiv7172624434bold a {text-decoration:none;}#yiv7172624434 dd.yiv7172624434last p a {font-family:Verdana;font-weight:700;}#yiv7172624434 dd.yiv7172624434last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7172624434 dd.yiv7172624434last p span.yiv7172624434yshortcuts {margin-right:0;}#yiv7172624434 div.yiv7172624434attach-table div div a {text-decoration:none;}#yiv7172624434 div.yiv7172624434attach-table {width:400px;}#yiv7172624434 div.yiv7172624434file-title a, #yiv7172624434 div.yiv7172624434file-title a:active, #yiv7172624434 div.yiv7172624434file-title a:hover, #yiv7172624434 div.yiv7172624434file-title a:visited {text-decoration:none;}#yiv7172624434 div.yiv7172624434photo-title a, #yiv7172624434 div.yiv7172624434photo-title a:active, #yiv7172624434 div.yiv7172624434photo-title a:hover, #yiv7172624434 div.yiv7172624434photo-title a:visited {text-decoration:none;}#yiv7172624434 div#yiv7172624434ygrp-mlmsg #yiv7172624434ygrp-msg p a span.yiv7172624434yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7172624434 .yiv7172624434green {color:#628c2a;}#yiv7172624434 .yiv7172624434MsoNormal {margin:0 0 0 0;}#yiv7172624434 o {font-size:0;}#yiv7172624434 #yiv7172624434photos div {float:left;width:72px;}#yiv7172624434 #yiv7172624434photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv7172624434 #yiv7172624434photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7172624434 #yiv7172624434reco-category {font-size:77%;}#yiv7172624434 #yiv7172624434reco-desc {font-size:77%;}#yiv7172624434 .yiv7172624434replbq {margin:4px;}#yiv7172624434 #yiv7172624434ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7172624434 #yiv7172624434ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7172624434 #yiv7172624434ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7172624434 #yiv7172624434ygrp-mlmsg select, #yiv7172624434 input, #yiv7172624434 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7172624434 #yiv7172624434ygrp-mlmsg pre, #yiv7172624434 code {font:115% monospace;}#yiv7172624434 #yiv7172624434ygrp-mlmsg * {line-height:1.22em;}#yiv7172624434 #yiv7172624434ygrp-mlmsg #yiv7172624434logo {padding-bottom:10px;}#yiv7172624434 #yiv7172624434ygrp-msg p a {font-family:Verdana;}#yiv7172624434 #yiv7172624434ygrp-msg p#yiv7172624434attach-count span {color:#1E66AE;font-weight:700;}#yiv7172624434 #yiv7172624434ygrp-reco #yiv7172624434reco-head {color:#ff7900;font-weight:700;}#yiv7172624434 #yiv7172624434ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7172624434 #yiv7172624434ygrp-sponsor #yiv7172624434ov li a {font-size:130%;text-decoration:none;}#yiv7172624434 #yiv7172624434ygrp-sponsor #yiv7172624434ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7172624434 #yiv7172624434ygrp-sponsor #yiv7172624434ov ul {margin:0;padding:0 0 0 8px;}#yiv7172624434 #yiv7172624434ygrp-text {font-family:Georgia;}#yiv7172624434 #yiv7172624434ygrp-text p {margin:0 0 1em 0;}#yiv7172624434 #yiv7172624434ygrp-text tt {font-size:120%;}#yiv7172624434 #yiv7172624434ygrp-vital ul li:last-child {border-right:none !important;}#yiv7172624434

=?UTF-8?b?QXVkaXQgU2VxIGVkaXQueGxzeA==?= (128K) Download Attachment
1574656044295blob.jpg (143K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] menampilkan data dengan memilih data dari List Box ActiveX Controls

HAIRUL ALAM
 Salam Mas Sony
bisakah kalau hanya menggunakan 1 listbox saja untuk menampilkan data seperti terlampir diatas jadi bila data yang dilistbox di klik maka muncul data sesuai lookup dari yang diklik
TerimakasihHairul Alam    Pada Senin, 25 November 2019 20.07.20 WIB, HAIRUL ALAM <[hidden email]> menulis:

  Salam Mas Sony
Kalau seperti terlampir seperti apa code macronya ya
Terimakasih
Assalamualaikum
    Pada Senin, 25 November 2019 18.49.21 WIB, HAIRUL ALAM <[hidden email]> menulis:

  Terimakasih Mas Sony,
SalamHairul Alam
    Pada Senin, 25 November 2019 15.50.12 WIB, Sony Ario [hidden email] [belajar-excel] <[hidden email]> menulis:

  

Waalaikumsalaam.
Sambil tunggu yg lain. Ini dari saya...
Difile yang saya lampirkan listbox nya hanya ada 2. Maaf saya kurang paham knp harus ada 6 ya.
Semoga membantu.
Wassalam


On Mon, Nov 25, 2019 at 2:30 PM HAIRUL ALAM [hidden email] [belajar-excel] <[hidden email]> wrote:

  

Salam Member
Selamat Pagi
Semoga selalu dalam keadaan sehat
hendak membuat link data dari List Box ActiveX Controls Excel cuma belum dapat caranya.
seperti data terlampir



Mohon solusinya
Terimakasih
Assalamualaikum


  #yiv7172624434 -- #yiv7172624434ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7172624434 #yiv7172624434ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7172624434 #yiv7172624434ygrp-mkp #yiv7172624434hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7172624434 #yiv7172624434ygrp-mkp #yiv7172624434ads {margin-bottom:10px;}#yiv7172624434 #yiv7172624434ygrp-mkp .yiv7172624434ad {padding:0 0;}#yiv7172624434 #yiv7172624434ygrp-mkp .yiv7172624434ad p {margin:0;}#yiv7172624434 #yiv7172624434ygrp-mkp .yiv7172624434ad a {color:#0000ff;text-decoration:none;}#yiv7172624434 #yiv7172624434ygrp-sponsor #yiv7172624434ygrp-lc {font-family:Arial;}#yiv7172624434 #yiv7172624434ygrp-sponsor #yiv7172624434ygrp-lc #yiv7172624434hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7172624434 #yiv7172624434ygrp-sponsor #yiv7172624434ygrp-lc .yiv7172624434ad {margin-bottom:10px;padding:0 0;}#yiv7172624434 #yiv7172624434actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7172624434 #yiv7172624434activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7172624434 #yiv7172624434activity span {font-weight:700;}#yiv7172624434 #yiv7172624434activity span:first-child {text-transform:uppercase;}#yiv7172624434 #yiv7172624434activity span a {color:#5085b6;text-decoration:none;}#yiv7172624434 #yiv7172624434activity span span {color:#ff7900;}#yiv7172624434 #yiv7172624434activity span .yiv7172624434underline {text-decoration:underline;}#yiv7172624434 .yiv7172624434attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7172624434 .yiv7172624434attach div a {text-decoration:none;}#yiv7172624434 .yiv7172624434attach img {border:none;padding-right:5px;}#yiv7172624434 .yiv7172624434attach label {display:block;margin-bottom:5px;}#yiv7172624434 .yiv7172624434attach label a {text-decoration:none;}#yiv7172624434 blockquote {margin:0 0 0 4px;}#yiv7172624434 .yiv7172624434bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7172624434 .yiv7172624434bold a {text-decoration:none;}#yiv7172624434 dd.yiv7172624434last p a {font-family:Verdana;font-weight:700;}#yiv7172624434 dd.yiv7172624434last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7172624434 dd.yiv7172624434last p span.yiv7172624434yshortcuts {margin-right:0;}#yiv7172624434 div.yiv7172624434attach-table div div a {text-decoration:none;}#yiv7172624434 div...yiv7172624434attach-table {width:400px;}#yiv7172624434 div.yiv7172624434file-title a, #yiv7172624434 div.yiv7172624434file-title a:active, #yiv7172624434 div.yiv7172624434file-title a:hover, #yiv7172624434 div.yiv7172624434file-title a:visited {text-decoration:none;}#yiv7172624434 div.yiv7172624434photo-title a, #yiv7172624434 div.yiv7172624434photo-title a:active, #yiv7172624434 div.yiv7172624434photo-title a:hover, #yiv7172624434 div.yiv7172624434photo-title a:visited {text-decoration:none;}#yiv7172624434 div#yiv7172624434ygrp-mlmsg #yiv7172624434ygrp-msg p a span.yiv7172624434yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7172624434 .yiv7172624434green {color:#628c2a;}#yiv7172624434 .yiv7172624434MsoNormal {margin:0 0 0 0;}#yiv7172624434 o {font-size:0;}#yiv7172624434 #yiv7172624434photos div {float:left;width:72px;}#yiv7172624434 #yiv7172624434photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv7172624434 #yiv7172624434photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7172624434 #yiv7172624434reco-category {font-size:77%;}#yiv7172624434 #yiv7172624434reco-desc {font-size:77%;}#yiv7172624434 .yiv7172624434replbq {margin:4px;}#yiv7172624434 #yiv7172624434ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7172624434 #yiv7172624434ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7172624434 #yiv7172624434ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7172624434 #yiv7172624434ygrp-mlmsg select, #yiv7172624434 input, #yiv7172624434 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7172624434 #yiv7172624434ygrp-mlmsg pre, #yiv7172624434 code {font:115% monospace;}#yiv7172624434 #yiv7172624434ygrp-mlmsg * {line-height:1.22em;}#yiv7172624434 #yiv7172624434ygrp-mlmsg #yiv7172624434logo {padding-bottom:10px;}#yiv7172624434 #yiv7172624434ygrp-msg p a {font-family:Verdana;}#yiv7172624434 #yiv7172624434ygrp-msg p#yiv7172624434attach-count span {color:#1E66AE;font-weight:700;}#yiv7172624434 #yiv7172624434ygrp-reco #yiv7172624434reco-head {color:#ff7900;font-weight:700;}#yiv7172624434 #yiv7172624434ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7172624434 #yiv7172624434ygrp-sponsor #yiv7172624434ov li a {font-size:130%;text-decoration:none;}#yiv7172624434 #yiv7172624434ygrp-sponsor #yiv7172624434ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7172624434 #yiv7172624434ygrp-sponsor #yiv7172624434ov ul {margin:0;padding:0 0 0 8px;}#yiv7172624434 #yiv7172624434ygrp-text {font-family:Georgia;}#yiv7172624434 #yiv7172624434ygrp-text p {margin:0 0 1em 0;}#yiv7172624434 #yiv7172624434ygrp-text tt {font-size:120%;}#yiv7172624434 #yiv7172624434ygrp-vital ul li:last-child {border-right:none !important;}#yiv7172624434  

1574656044295blob.jpg (143K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] menampilkan data dengan memilih data dari List Box ActiveX Controls

Sony Ario
kelihatan nya pake rumus itu mas Hairul.
seperti rumus lookup. Ada di kolom D dan I.

=IFERROR(INDIRECT("G"&SMALL(IF($F$3:$F$540=B$3,ROW($G$3:$G$540)),ROW(1:1))),"")

Disini banyak pakar rumus Excel. Kita tunggu aja.


On Wed, Nov 27, 2019 at 7:33 AM HAIRUL ALAM [hidden email]
[belajar-excel] <[hidden email]> wrote:

>
>
> Salam Mas Sony
>
> bisakah kalau hanya menggunakan 1 listbox saja untuk menampilkan data
> seperti terlampir diatas jadi bila data yang dilistbox di klik maka muncul
> data sesuai lookup dari yang diklik
>
> Terimakasih
> Hairul Alam
> Pada Senin, 25 November 2019 20.07.20 WIB, HAIRUL ALAM <
> [hidden email]> menulis:
>
>
> Salam Mas Sony
>
> Kalau seperti terlampir seperti apa code macronya ya
>
> Terimakasih
>
> Assalamualaikum
>
> Pada Senin, 25 November 2019 18.49.21 WIB, HAIRUL ALAM <
> [hidden email]> menulis:
>
>
> Terimakasih Mas Sony,
>
> Salam
> Hairul Alam
>
> Pada Senin, 25 November 2019 15.50.12 WIB, Sony Ario [hidden email]
> [belajar-excel] <[hidden email]> menulis:
>
>
>
>
> Waalaikumsalaam.
>
> Sambil tunggu yg lain. Ini dari saya.
>
> Difile yang saya lampirkan listbox nya hanya ada 2. Maaf saya kurang paham
> knp harus ada 6 ya.
>
> Semoga membantu.
>
> Wassalam
>
>
>
> On Mon, Nov 25, 2019 at 2:30 PM HAIRUL ALAM [hidden email]
> [belajar-excel] <[hidden email]> wrote:
>
>
>
> Salam Member
>
> Selamat Pagi
>
> Semoga selalu dalam keadaan sehat
>
> hendak membuat link data dari List Box ActiveX Controls Excel cuma belum
> dapat caranya.
>
> seperti data terlampir
>
> [image: Jadikan gambar sebaris]
>
>
> Mohon solusinya
>
> Terimakasih
>
> Assalamualaikum
>
>
>

1574656044295blob.jpg (143K) Download Attachment
Kid
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] menampilkan data dengan memilih data dari List Box ActiveX Controls [1 Attachment]

Kid
Administrator
In reply to this post by HAIRUL ALAM
Excel 2010 ke atas sudah ada fitur Slicer.
Tanpa perlu VBA (macro)


On Mon, Nov 25, 2019 at 2:30 PM HAIRUL ALAM [hidden email]
[belajar-excel] <[hidden email]> wrote:

>
>
> Salam Member
>
> Selamat Pagi
>
> Semoga selalu dalam keadaan sehat
>
> hendak membuat link data dari List Box ActiveX Controls Excel cuma belum
> dapat caranya.
>
> seperti data terlampir
>
> [image: Jadikan gambar sebaris]
>
>
> Mohon solusinya
>
> Terimakasih
>
> Assalamualaikum
>
>
>

1574656044295blob.jpg (143K) Download Attachment
re-link data List Box ActiveX Controls.xlsx (37K) Download Attachment