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' mr.nm...@gmail.com
[belajar-excel] <belajar-excel@yahoogroups.com> 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 ha_m...@yahoo.co.id [belajar-excel]
<belajar-excel@yahoogroups.com> 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' 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
#yiv9689611194 #yiv9689611194 -- #yiv9689611194ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9689611194
#yiv9689611194ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9689611194
#yiv9689611194ygrp-mkp #yiv9689611194hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9689611194 #yiv9689611194ygrp-mkp #yiv9689611194ads
{margin-bottom:10px;}#yiv9689611194 #yiv9689611194ygrp-mkp .yiv9689611194ad
{padding:0 0;}#yiv9689611194 #yiv9689611194ygrp-mkp .yiv9689611194ad p
{margin:0;}#yiv9689611194 #yiv9689611194ygrp-mkp .yiv9689611194ad a
{color:#0000ff;text-decoration:none;}#yiv9689611194 #yiv9689611194ygrp-sponsor
#yiv9689611194ygrp-lc {font-family:Arial;}#yiv9689611194
#yiv9689611194ygrp-sponsor #yiv9689611194ygrp-lc #yiv9689611194hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9689611194
#yiv9689611194ygrp-sponsor #yiv9689611194ygrp-lc .yiv9689611194ad
{margin-bottom:10px;padding:0 0;}#yiv9689611194 #yiv9689611194actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9689611194
#yiv9689611194activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9689611194
#yiv9689611194activity span {font-weight:700;}#yiv9689611194
#yiv9689611194activity span:first-child
{text-transform:uppercase;}#yiv9689611194 #yiv9689611194activity span a
{color:#5085b6;text-decoration:none;}#yiv9689611194 #yiv9689611194activity span
span {color:#ff7900;}#yiv9689611194 #yiv9689611194activity span
.yiv9689611194underline {text-decoration:underline;}#yiv9689611194
.yiv9689611194attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9689611194 .yiv9689611194attach div a
{text-decoration:none;}#yiv9689611194 .yiv9689611194attach img
{border:none;padding-right:5px;}#yiv9689611194 .yiv9689611194attach label
{display:block;margin-bottom:5px;}#yiv9689611194 .yiv9689611194attach label a
{text-decoration:none;}#yiv9689611194 blockquote {margin:0 0 0
4px;}#yiv9689611194 .yiv9689611194bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9689611194
.yiv9689611194bold a {text-decoration:none;}#yiv9689611194 dd.yiv9689611194last
p a {font-family:Verdana;font-weight:700;}#yiv9689611194 dd...yiv9689611194last
p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9689611194
dd.yiv9689611194last p span.yiv9689611194yshortcuts
{margin-right:0;}#yiv9689611194 div.yiv9689611194attach-table div div a
{text-decoration:none;}#yiv9689611194 div.yiv9689611194attach-table
{width:400px;}#yiv9689611194 div.yiv9689611194file-title a, #yiv9689611194
div.yiv9689611194file-title a:active, #yiv9689611194
div.yiv9689611194file-title a:hover, #yiv9689611194 div.yiv9689611194file-title
a:visited {text-decoration:none;}#yiv9689611194 div.yiv9689611194photo-title a,
#yiv9689611194 div.yiv9689611194photo-title a:active, #yiv9689611194
div.yiv9689611194photo-title a:hover, #yiv9689611194
div.yiv9689611194photo-title a:visited {text-decoration:none;}#yiv9689611194
div#yiv9689611194ygrp-mlmsg #yiv9689611194ygrp-msg p a
span.yiv9689611194yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9689611194
.yiv9689611194green {color:#628c2a;}#yiv9689611194 .yiv9689611194MsoNormal
{margin:0 0 0 0;}#yiv9689611194 o {font-size:0;}#yiv9689611194
#yiv9689611194photos div {float:left;width:72px;}#yiv9689611194
#yiv9689611194photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv9689611194
#yiv9689611194photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9689611194
#yiv9689611194reco-category {font-size:77%;}#yiv9689611194
#yiv9689611194reco-desc {font-size:77%;}#yiv9689611194 .yiv9689611194replbq
{margin:4px;}#yiv9689611194 #yiv9689611194ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9689611194 #yiv9689611194ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9689611194
#yiv9689611194ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9689611194
#yiv9689611194ygrp-mlmsg select, #yiv9689611194 input, #yiv9689611194 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9689611194
#yiv9689611194ygrp-mlmsg pre, #yiv9689611194 code {font:115%
monospace;}#yiv9689611194 #yiv9689611194ygrp-mlmsg *
{line-height:1.22em;}#yiv9689611194 #yiv9689611194ygrp-mlmsg #yiv9689611194logo
{padding-bottom:10px;}#yiv9689611194 #yiv9689611194ygrp-msg p a
{font-family:Verdana;}#yiv9689611194 #yiv9689611194ygrp-msg
p#yiv9689611194attach-count span {color:#1E66AE;font-weight:700;}#yiv9689611194
#yiv9689611194ygrp-reco #yiv9689611194reco-head
{color:#ff7900;font-weight:700;}#yiv9689611194 #yiv9689611194ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9689611194 #yiv9689611194ygrp-sponsor
#yiv9689611194ov li a {font-size:130%;text-decoration:none;}#yiv9689611194
#yiv9689611194ygrp-sponsor #yiv9689611194ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9689611194
#yiv9689611194ygrp-sponsor #yiv9689611194ov ul {margin:0;padding:0 0 0
8px;}#yiv9689611194 #yiv9689611194ygrp-text
{font-family:Georgia;}#yiv9689611194 #yiv9689611194ygrp-text p {margin:0 0 1em
0;}#yiv9689611194 #yiv9689611194ygrp-text tt {font-size:120%;}#yiv9689611194
#yiv9689611194ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9689611194
