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' [email protected]
[belajar-excel] <[email protected]> menulis:
File terlampir
Regards,Kid#gakasikkalopakevba
On Sun, Sep 1, 2019 at 3:32 PM HAIRUL ALAM [email protected] [belajar-excel]
<[email protected]> 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
