Salam Mr.KidTerimakasih BanyakSudah bisa, Maaf saya kurang menyimak AssalamualaikumHairul Alam
Dikirim dari Yahoo Mail di Android Pada Rab, 4 Sep 2019 pada 13:53, HAIRUL ALAM [email protected] [belajar-excel]<[email protected]> menulis: Salam Mr.Kid Terimakasih, saya sudah paham passwordnya, cuma yang belum paham bagaimana menggunakan validasi agar bisa lookup dengan Box list seperti yang di lampirkan oleh Mr.Kid, Maaf Terimakasih BanyakHairul Alam Pada Rabu, 4 September 2019 12.50.38 GMT+7, 'Mr. Kid' [email protected] [belajar-excel] <[email protected]> menulis: Wa'alaikumussalam wr wb hehehe...semua password (andai part di dalam file atau si file itu sendiri diproteksi) sudah disediakan kok. Kalau gak ada di dalam file, berarti ada di dalam imil.sekali-kali main tebak-tebakan mencari password ya... BeExceller siapa saja bisa membantu kok...tujuan proteksi sekadar untuk wacana saja, kalau pengennya diimplementasi pakai proteksi, bisa seperti itu.Jadi proteksi itu bukan untuk menjaga atau melindungi ilmu supaya sulit dipelajari loh ya... Wa'alaikumussalam wr wbKid#gakasikkalopakevba On Wed, Sep 4, 2019 at 10:56 AM HAIRUL ALAM [email protected] [belajar-excel] <[email protected]> wrote: 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 #yiv1227640222 #yiv1227640222 -- #yiv1227640222ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1227640222 #yiv1227640222ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1227640222 #yiv1227640222ygrp-mkp #yiv1227640222hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1227640222 #yiv1227640222ygrp-mkp #yiv1227640222ads {margin-bottom:10px;}#yiv1227640222 #yiv1227640222ygrp-mkp .yiv1227640222ad {padding:0 0;}#yiv1227640222 #yiv1227640222ygrp-mkp .yiv1227640222ad p {margin:0;}#yiv1227640222 #yiv1227640222ygrp-mkp .yiv1227640222ad a {color:#0000ff;text-decoration:none;}#yiv1227640222 #yiv1227640222ygrp-sponsor #yiv1227640222ygrp-lc {font-family:Arial;}#yiv1227640222 #yiv1227640222ygrp-sponsor #yiv1227640222ygrp-lc #yiv1227640222hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1227640222 #yiv1227640222ygrp-sponsor #yiv1227640222ygrp-lc .yiv1227640222ad {margin-bottom:10px;padding:0 0;}#yiv1227640222 #yiv1227640222actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1227640222 #yiv1227640222activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1227640222 #yiv1227640222activity span {font-weight:700;}#yiv1227640222 #yiv1227640222activity span:first-child {text-transform:uppercase;}#yiv1227640222 #yiv1227640222activity span a {color:#5085b6;text-decoration:none;}#yiv1227640222 #yiv1227640222activity span span {color:#ff7900;}#yiv1227640222 #yiv1227640222activity span .yiv1227640222underline {text-decoration:underline;}#yiv1227640222 .yiv1227640222attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1227640222 .yiv1227640222attach div a {text-decoration:none;}#yiv1227640222 .yiv1227640222attach img {border:none;padding-right:5px;}#yiv1227640222 .yiv1227640222attach label {display:block;margin-bottom:5px;}#yiv1227640222 .yiv1227640222attach label a {text-decoration:none;}#yiv1227640222 blockquote {margin:0 0 0 4px;}#yiv1227640222 .yiv1227640222bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1227640222 .yiv1227640222bold a {text-decoration:none;}#yiv1227640222 dd.yiv1227640222last p a {font-family:Verdana;font-weight:700;}#yiv1227640222 dd.yiv1227640222last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1227640222 dd...yiv1227640222last p span.yiv1227640222yshortcuts {margin-right:0;}#yiv1227640222 div.yiv1227640222attach-table div div a {text-decoration:none;}#yiv1227640222 div.yiv1227640222attach-table {width:400px;}#yiv1227640222 div.yiv1227640222file-title a, #yiv1227640222 div.yiv1227640222file-title a:active, #yiv1227640222 div.yiv1227640222file-title a:hover, #yiv1227640222 div.yiv1227640222file-title a:visited {text-decoration:none;}#yiv1227640222 div.yiv1227640222photo-title a, #yiv1227640222 div.yiv1227640222photo-title a:active, #yiv1227640222 div.yiv1227640222photo-title a:hover, #yiv1227640222 div.yiv1227640222photo-title a:visited {text-decoration:none;}#yiv1227640222 div#yiv1227640222ygrp-mlmsg #yiv1227640222ygrp-msg p a span.yiv1227640222yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1227640222 .yiv1227640222green {color:#628c2a;}#yiv1227640222 .yiv1227640222MsoNormal {margin:0 0 0 0;}#yiv1227640222 o {font-size:0;}#yiv1227640222 #yiv1227640222photos div {float:left;width:72px;}#yiv1227640222 #yiv1227640222photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv1227640222 #yiv1227640222photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1227640222 #yiv1227640222reco-category {font-size:77%;}#yiv1227640222 #yiv1227640222reco-desc {font-size:77%;}#yiv1227640222 .yiv1227640222replbq {margin:4px;}#yiv1227640222 #yiv1227640222ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1227640222 #yiv1227640222ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1227640222 #yiv1227640222ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1227640222 #yiv1227640222ygrp-mlmsg select, #yiv1227640222 input, #yiv1227640222 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1227640222 #yiv1227640222ygrp-mlmsg pre, #yiv1227640222 code {font:115% monospace;}#yiv1227640222 #yiv1227640222ygrp-mlmsg * {line-height:1.22em;}#yiv1227640222 #yiv1227640222ygrp-mlmsg #yiv1227640222logo {padding-bottom:10px;}#yiv1227640222 #yiv1227640222ygrp-msg p a {font-family:Verdana;}#yiv1227640222 #yiv1227640222ygrp-msg p#yiv1227640222attach-count span {color:#1E66AE;font-weight:700;}#yiv1227640222 #yiv1227640222ygrp-reco #yiv1227640222reco-head {color:#ff7900;font-weight:700;}#yiv1227640222 #yiv1227640222ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1227640222 #yiv1227640222ygrp-sponsor #yiv1227640222ov li a {font-size:130%;text-decoration:none;}#yiv1227640222 #yiv1227640222ygrp-sponsor #yiv1227640222ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1227640222 #yiv1227640222ygrp-sponsor #yiv1227640222ov ul {margin:0;padding:0 0 0 8px;}#yiv1227640222 #yiv1227640222ygrp-text {font-family:Georgia;}#yiv1227640222 #yiv1227640222ygrp-text p {margin:0 0 1em 0;}#yiv1227640222 #yiv1227640222ygrp-text tt {font-size:120%;}#yiv1227640222 #yiv1227640222ygrp-vital ul li:last-child {border-right:none !important;}#yiv1227640222
