terimakasih banyak Mr Suyono...alhmdlah berjalan,,
Pada Jumat, 18 September 2015 17:03, "SUYONO reza.suy...@lge.com
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Dear Pak Achmad, Mungkin bisa diganti seperti ini pak. SBDATA.Value = 5
+ listcari.List(listcari.ListIndex, 0) Semoga sesuai, keinginan. Wasalam,
Yono From:belajar-excel@yahoogroups.com
[mailto:belajar-excel@yahoogroups.com]
Sent: Friday, September 18, 2015 8:32 AM
To: belajar-excel@yahoogroups.com
Subject: Bls: [belajar-excel] scrollbar untuk menjalankan isi di 2listbox [1
Attachment] dear Mr kid,,, saya dah oprek2,,,file
saya,,tapimentok,,,pas milih salah satu list dilistbox,,eror,, mohon
bantuannya,,,ini saya lampirkanfilenya Pada Minggu, 13 September 20150:50,
"'Mr. Kid' mr.nm...@gmail.com [belajar-excel]"<belajar-excel@yahoogroups.com>
menulis: Untuk scroll dengan mouse wheelpada combobox ataupun listbox
bisa dilihat di file yang ada disini. Wassalam, Kid 2015-09-10 15:52
GMT+07:00 achmad adi dido...@ymail.com[belajar-excel]
<belajar-excel@yahoogroups.com>:
dear master excel.. setelah ada penjelasan untuk millissebelumnya ( 2
listbox 1 tujuan ).. saya mencoba kembangkan file tsb untukinput data dimana
isinya bisa discroll menurut list terpilih di listbox tsb.. bagaimana caranya
supaya scrollberfungsi untuk menggerakan isi listobox? dan pertanyaan satu
lagi,, untuk mencari opening value,, dimana opening value mengacu dari kolomK (
Budget ) dengan mengambil data terakhir. ini saya lampirkan filenya,,
sebelumnya saya ucapkan banyakterimakasih
#yiv4758519156 #yiv4758519156 -- #yiv4758519156ygrp-mkp {border:1px
solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4758519156
#yiv4758519156ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4758519156
#yiv4758519156ygrp-mkp #yiv4758519156hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4758519156 #yiv4758519156ygrp-mkp #yiv4758519156ads
{margin-bottom:10px;}#yiv4758519156 #yiv4758519156ygrp-mkp .yiv4758519156ad
{padding:0 0;}#yiv4758519156 #yiv4758519156ygrp-mkp .yiv4758519156ad p
{margin:0;}#yiv4758519156 #yiv4758519156ygrp-mkp .yiv4758519156ad a
{color:#0000ff;text-decoration:none;}#yiv4758519156 #yiv4758519156ygrp-sponsor
#yiv4758519156ygrp-lc {font-family:Arial;}#yiv4758519156
#yiv4758519156ygrp-sponsor #yiv4758519156ygrp-lc #yiv4758519156hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4758519156
#yiv4758519156ygrp-sponsor #yiv4758519156ygrp-lc .yiv4758519156ad
{margin-bottom:10px;padding:0 0;}#yiv4758519156 #yiv4758519156actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4758519156
#yiv4758519156activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4758519156
#yiv4758519156activity span {font-weight:700;}#yiv4758519156
#yiv4758519156activity span:first-child
{text-transform:uppercase;}#yiv4758519156 #yiv4758519156activity span a
{color:#5085b6;text-decoration:none;}#yiv4758519156 #yiv4758519156activity span
span {color:#ff7900;}#yiv4758519156 #yiv4758519156activity span
.yiv4758519156underline {text-decoration:underline;}#yiv4758519156
.yiv4758519156attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4758519156 .yiv4758519156attach div a
{text-decoration:none;}#yiv4758519156 .yiv4758519156attach img
{border:none;padding-right:5px;}#yiv4758519156 .yiv4758519156attach label
{display:block;margin-bottom:5px;}#yiv4758519156 .yiv4758519156attach label a
{text-decoration:none;}#yiv4758519156 blockquote {margin:0 0 0
4px;}#yiv4758519156 .yiv4758519156bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4758519156
.yiv4758519156bold a {text-decoration:none;}#yiv4758519156 dd.yiv4758519156last
p a {font-family:Verdana;font-weight:700;}#yiv4758519156 dd.yiv4758519156last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4758519156
dd.yiv4758519156last p span.yiv4758519156yshortcuts
{margin-right:0;}#yiv4758519156 div.yiv4758519156attach-table div div a
{text-decoration:none;}#yiv4758519156 div.yiv4758519156attach-table
{width:400px;}#yiv4758519156 div.yiv4758519156file-title a, #yiv4758519156
div.yiv4758519156file-title a:active, #yiv4758519156
div.yiv4758519156file-title a:hover, #yiv4758519156 div.yiv4758519156file-title
a:visited {text-decoration:none;}#yiv4758519156 div.yiv4758519156photo-title a,
#yiv4758519156 div.yiv4758519156photo-title a:active, #yiv4758519156
div.yiv4758519156photo-title a:hover, #yiv4758519156
div.yiv4758519156photo-title a:visited {text-decoration:none;}#yiv4758519156
div#yiv4758519156ygrp-mlmsg #yiv4758519156ygrp-msg p a
span.yiv4758519156yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4758519156
.yiv4758519156green {color:#628c2a;}#yiv4758519156 .yiv4758519156MsoNormal
{margin:0 0 0 0;}#yiv4758519156 o {font-size:0;}#yiv4758519156
#yiv4758519156photos div {float:left;width:72px;}#yiv4758519156
#yiv4758519156photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv4758519156
#yiv4758519156photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4758519156
#yiv4758519156reco-category {font-size:77%;}#yiv4758519156
#yiv4758519156reco-desc {font-size:77%;}#yiv4758519156 .yiv4758519156replbq
{margin:4px;}#yiv4758519156 #yiv4758519156ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4758519156 #yiv4758519156ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4758519156
#yiv4758519156ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4758519156
#yiv4758519156ygrp-mlmsg select, #yiv4758519156 input, #yiv4758519156 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4758519156
#yiv4758519156ygrp-mlmsg pre, #yiv4758519156 code {font:115%
monospace;}#yiv4758519156 #yiv4758519156ygrp-mlmsg *
{line-height:1.22em;}#yiv4758519156 #yiv4758519156ygrp-mlmsg #yiv4758519156logo
{padding-bottom:10px;}#yiv4758519156 #yiv4758519156ygrp-msg p a
{font-family:Verdana;}#yiv4758519156 #yiv4758519156ygrp-msg
p#yiv4758519156attach-count span {color:#1E66AE;font-weight:700;}#yiv4758519156
#yiv4758519156ygrp-reco #yiv4758519156reco-head
{color:#ff7900;font-weight:700;}#yiv4758519156 #yiv4758519156ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv4758519156 #yiv4758519156ygrp-sponsor
#yiv4758519156ov li a {font-size:130%;text-decoration:none;}#yiv4758519156
#yiv4758519156ygrp-sponsor #yiv4758519156ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4758519156
#yiv4758519156ygrp-sponsor #yiv4758519156ov ul {margin:0;padding:0 0 0
8px;}#yiv4758519156 #yiv4758519156ygrp-text
{font-family:Georgia;}#yiv4758519156 #yiv4758519156ygrp-text p {margin:0 0 1em
0;}#yiv4758519156 #yiv4758519156ygrp-text tt {font-size:120%;}#yiv4758519156
#yiv4758519156ygrp-vital ul li:last-child {border-right:none
!important;}#yiv4758519156
