|
|
|
|
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
|
|
|
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.
|
|
|
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
>
>
>
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
>
>
>
|
|
Administrator
|
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
>
>
>
|
|
Locked
link data List Box ActiveX Controls.xlsx (26K) 