Assalamualaikum Mr,Kid
Terimakasih filenya, Maaf tapi password filenya nda bisa saya buka itu gunakan 
menu apa ya Master
Maaf, Terimakasih
WassalamualaikumHairul Alam
    Pada Rabu, 4 September 2019 00.06.12 WIB, 'Mr. Kid' mr.nm...@gmail.com 
[belajar-excel] <belajar-excel@yahoogroups.com> menulis: 

  

File terlampir
Regards,Kid#gakasikkalopakevba 


On Sun, Sep 1, 2019 at 3:32 PM HAIRUL ALAM ha_m...@yahoo.co.id [belajar-excel] 
<belajar-excel@yahoogroups.com> wrote:

  

SalamRekan Rekan BeExcel
Selamat Malam
Semoga selalu dalam keadaan sehat
saya ingin menampilkan data pada listbox di worksheet excel dengan macro
bila saya menggunakan code macro :

PrivateSub TextBox1_Change()

Range("B7").Value= TextBox1.Value

EndSub

bila saya isi data di B7 dengan kata "SEQUENCE" maka di listbox akan tetap 
muncul "SEQUENCE"bagaimana code macronya bila pada B7 saya ketikkan "SEQUENCE" 
maka di listbox akan muncul :
1. Tender2. Vendor3. Construction4. Pre-Commissioning5. Mechanical Completion6. 
Handover
seperti data terlampir
Terimakasih
AssalamualaikumHairul Alam




  #yiv4118881435 #yiv4118881435 -- #yiv4118881435ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4118881435 
#yiv4118881435ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4118881435 
#yiv4118881435ygrp-mkp #yiv4118881435hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv4118881435 #yiv4118881435ygrp-mkp #yiv4118881435ads 
{margin-bottom:10px;}#yiv4118881435 #yiv4118881435ygrp-mkp .yiv4118881435ad 
{padding:0 0;}#yiv4118881435 #yiv4118881435ygrp-mkp .yiv4118881435ad p 
{margin:0;}#yiv4118881435 #yiv4118881435ygrp-mkp .yiv4118881435ad a 
{color:#0000ff;text-decoration:none;}#yiv4118881435 #yiv4118881435ygrp-sponsor 
#yiv4118881435ygrp-lc {font-family:Arial;}#yiv4118881435 
#yiv4118881435ygrp-sponsor #yiv4118881435ygrp-lc #yiv4118881435hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4118881435 
#yiv4118881435ygrp-sponsor #yiv4118881435ygrp-lc .yiv4118881435ad 
{margin-bottom:10px;padding:0 0;}#yiv4118881435 #yiv4118881435actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4118881435 
#yiv4118881435activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4118881435
 #yiv4118881435activity span {font-weight:700;}#yiv4118881435 
#yiv4118881435activity span:first-child 
{text-transform:uppercase;}#yiv4118881435 #yiv4118881435activity span a 
{color:#5085b6;text-decoration:none;}#yiv4118881435 #yiv4118881435activity span 
span {color:#ff7900;}#yiv4118881435 #yiv4118881435activity span 
.yiv4118881435underline {text-decoration:underline;}#yiv4118881435 
.yiv4118881435attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv4118881435 .yiv4118881435attach div a 
{text-decoration:none;}#yiv4118881435 .yiv4118881435attach img 
{border:none;padding-right:5px;}#yiv4118881435 .yiv4118881435attach label 
{display:block;margin-bottom:5px;}#yiv4118881435 .yiv4118881435attach label a 
{text-decoration:none;}#yiv4118881435 blockquote {margin:0 0 0 
4px;}#yiv4118881435 .yiv4118881435bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4118881435 
.yiv4118881435bold a {text-decoration:none;}#yiv4118881435 dd.yiv4118881435last 
p a {font-family:Verdana;font-weight:700;}#yiv4118881435 dd.yiv4118881435last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4118881435 
dd.yiv4118881435last p span.yiv4118881435yshortcuts 
{margin-right:0;}#yiv4118881435 div.yiv4118881435attach-table div div a 
{text-decoration:none;}#yiv4118881435 div.yiv4118881435attach-table 
{width:400px;}#yiv4118881435 div.yiv4118881435file-title a, #yiv4118881435 
div.yiv4118881435file-title a:active, #yiv4118881435 
div.yiv4118881435file-title a:hover, #yiv4118881435 div.yiv4118881435file-title 
a:visited {text-decoration:none;}#yiv4118881435 div.yiv4118881435photo-title a, 
#yiv4118881435 div.yiv4118881435photo-title a:active, #yiv4118881435 
div.yiv4118881435photo-title a:hover, #yiv4118881435 
div.yiv4118881435photo-title a:visited {text-decoration:none;}#yiv4118881435 
div#yiv4118881435ygrp-mlmsg #yiv4118881435ygrp-msg p a 
span.yiv4118881435yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4118881435 
.yiv4118881435green {color:#628c2a;}#yiv4118881435 .yiv4118881435MsoNormal 
{margin:0 0 0 0;}#yiv4118881435 o {font-size:0;}#yiv4118881435 
#yiv4118881435photos div {float:left;width:72px;}#yiv4118881435 
#yiv4118881435photos div div {border:1px solid 
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv4118881435 
#yiv4118881435photos div label 
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4118881435
 #yiv4118881435reco-category {font-size:77%;}#yiv4118881435 
#yiv4118881435reco-desc {font-size:77%;}#yiv4118881435 .yiv4118881435replbq 
{margin:4px;}#yiv4118881435 #yiv4118881435ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv4118881435 #yiv4118881435ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4118881435 
#yiv4118881435ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4118881435 
#yiv4118881435ygrp-mlmsg select, #yiv4118881435 input, #yiv4118881435 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4118881435 
#yiv4118881435ygrp-mlmsg pre, #yiv4118881435 code {font:115% 
monospace;}#yiv4118881435 #yiv4118881435ygrp-mlmsg * 
{line-height:1.22em;}#yiv4118881435 #yiv4118881435ygrp-mlmsg #yiv4118881435logo 
{padding-bottom:10px;}#yiv4118881435 #yiv4118881435ygrp-msg p a 
{font-family:Verdana;}#yiv4118881435 #yiv4118881435ygrp-msg 
p#yiv4118881435attach-count span {color:#1E66AE;font-weight:700;}#yiv4118881435 
#yiv4118881435ygrp-reco #yiv4118881435reco-head 
{color:#ff7900;font-weight:700;}#yiv4118881435 #yiv4118881435ygrp-reco 
{margin-bottom:20px;padding:0px;}#yiv4118881435 #yiv4118881435ygrp-sponsor 
#yiv4118881435ov li a {font-size:130%;text-decoration:none;}#yiv4118881435 
#yiv4118881435ygrp-sponsor #yiv4118881435ov li 
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4118881435 
#yiv4118881435ygrp-sponsor #yiv4118881435ov ul {margin:0;padding:0 0 0 
8px;}#yiv4118881435 #yiv4118881435ygrp-text 
{font-family:Georgia;}#yiv4118881435 #yiv4118881435ygrp-text p {margin:0 0 1em 
0;}#yiv4118881435 #yiv4118881435ygrp-text tt {font-size:120%;}#yiv4118881435 
#yiv4118881435ygrp-vital ul li:last-child {border-right:none 
!important;}#yiv4118881435   
  • [belajar-excel] tampilkan ... HAIRUL ALAM ha_m...@yahoo.co.id [belajar-excel]
    • Re: [belajar-excel] t... 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]
      • Re: [belajar-exce... HAIRUL ALAM ha_m...@yahoo.co.id [belajar-excel]
        • Re: [belajar-... 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]
          • Re: [bela... HAIRUL ALAM ha_m...@yahoo.co.id [belajar-excel]
            • Bls:... HAIRUL ALAM ha_m...@yahoo.co.id [belajar-excel]
              • ... HAIRUL ALAM ha_m...@yahoo.co.id [belajar-excel]
                • ... 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]
                • ... HAIRUL ALAM ha_m...@yahoo.co.id [belajar-excel]
                • ... 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]
                • ... Agus nanga...@gmail.com [belajar-excel]
                • ... HAIRUL ALAM ha_m...@yahoo.co.id [belajar-excel]
                • ... 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]

Kirim email ke