oks..terimakasih banyak mr.kid...dipahami dulu,,,masukannya,,
Pada Minggu, 13 September 2015 0:50, "'Mr. Kid' mr.nm...@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Untuk scroll dengan mouse wheel pada 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 millis sebelumnya ( 2
listbox 1 tujuan )..saya mencoba kembangkan file tsb untuk input data dimana
isinya bisa discroll
menurut list terpilih di listbox tsb..bagaimana caranya supaya scroll berfungsi
untuk menggerakan isi listobox?dan pertanyaan satu lagi,,untuk mencari opening
value,,dimana opening value mengacu dari kolom K ( Budget ) dengan mengambil
data terakhir.
ini saya lampirkan filenya,,
sebelumnya saya ucapkan banyak terimakasih
#yiv4713350704 #yiv4713350704 -- #yiv4713350704ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4713350704
#yiv4713350704ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4713350704
#yiv4713350704ygrp-mkp #yiv4713350704hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4713350704 #yiv4713350704ygrp-mkp #yiv4713350704ads
{margin-bottom:10px;}#yiv4713350704 #yiv4713350704ygrp-mkp .yiv4713350704ad
{padding:0 0;}#yiv4713350704 #yiv4713350704ygrp-mkp .yiv4713350704ad p
{margin:0;}#yiv4713350704 #yiv4713350704ygrp-mkp .yiv4713350704ad a
{color:#0000ff;text-decoration:none;}#yiv4713350704 #yiv4713350704ygrp-sponsor
#yiv4713350704ygrp-lc {font-family:Arial;}#yiv4713350704
#yiv4713350704ygrp-sponsor #yiv4713350704ygrp-lc #yiv4713350704hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4713350704
#yiv4713350704ygrp-sponsor #yiv4713350704ygrp-lc .yiv4713350704ad
{margin-bottom:10px;padding:0 0;}#yiv4713350704 #yiv4713350704actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4713350704
#yiv4713350704activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4713350704
#yiv4713350704activity span {font-weight:700;}#yiv4713350704
#yiv4713350704activity span:first-child
{text-transform:uppercase;}#yiv4713350704 #yiv4713350704activity span a
{color:#5085b6;text-decoration:none;}#yiv4713350704 #yiv4713350704activity span
span {color:#ff7900;}#yiv4713350704 #yiv4713350704activity span
.yiv4713350704underline {text-decoration:underline;}#yiv4713350704
.yiv4713350704attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4713350704 .yiv4713350704attach div a
{text-decoration:none;}#yiv4713350704 .yiv4713350704attach img
{border:none;padding-right:5px;}#yiv4713350704 .yiv4713350704attach label
{display:block;margin-bottom:5px;}#yiv4713350704 .yiv4713350704attach label a
{text-decoration:none;}#yiv4713350704 blockquote {margin:0 0 0
4px;}#yiv4713350704 .yiv4713350704bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4713350704
.yiv4713350704bold a {text-decoration:none;}#yiv4713350704 dd.yiv4713350704last
p a {font-family:Verdana;font-weight:700;}#yiv4713350704 dd.yiv4713350704last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4713350704
dd.yiv4713350704last p span.yiv4713350704yshortcuts
{margin-right:0;}#yiv4713350704 div.yiv4713350704attach-table div div a
{text-decoration:none;}#yiv4713350704 div.yiv4713350704attach-table
{width:400px;}#yiv4713350704 div.yiv4713350704file-title a, #yiv4713350704
div.yiv4713350704file-title a:active, #yiv4713350704
div.yiv4713350704file-title a:hover, #yiv4713350704 div.yiv4713350704file-title
a:visited {text-decoration:none;}#yiv4713350704 div.yiv4713350704photo-title a,
#yiv4713350704 div.yiv4713350704photo-title a:active, #yiv4713350704
div.yiv4713350704photo-title a:hover, #yiv4713350704
div.yiv4713350704photo-title a:visited {text-decoration:none;}#yiv4713350704
div#yiv4713350704ygrp-mlmsg #yiv4713350704ygrp-msg p a
span.yiv4713350704yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4713350704
.yiv4713350704green {color:#628c2a;}#yiv4713350704 .yiv4713350704MsoNormal
{margin:0 0 0 0;}#yiv4713350704 o {font-size:0;}#yiv4713350704
#yiv4713350704photos div {float:left;width:72px;}#yiv4713350704
#yiv4713350704photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv4713350704
#yiv4713350704photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4713350704
#yiv4713350704reco-category {font-size:77%;}#yiv4713350704
#yiv4713350704reco-desc {font-size:77%;}#yiv4713350704 .yiv4713350704replbq
{margin:4px;}#yiv4713350704 #yiv4713350704ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4713350704 #yiv4713350704ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4713350704
#yiv4713350704ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4713350704
#yiv4713350704ygrp-mlmsg select, #yiv4713350704 input, #yiv4713350704 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4713350704
#yiv4713350704ygrp-mlmsg pre, #yiv4713350704 code {font:115%
monospace;}#yiv4713350704 #yiv4713350704ygrp-mlmsg *
{line-height:1.22em;}#yiv4713350704 #yiv4713350704ygrp-mlmsg #yiv4713350704logo
{padding-bottom:10px;}#yiv4713350704 #yiv4713350704ygrp-msg p a
{font-family:Verdana;}#yiv4713350704 #yiv4713350704ygrp-msg
p#yiv4713350704attach-count span {color:#1E66AE;font-weight:700;}#yiv4713350704
#yiv4713350704ygrp-reco #yiv4713350704reco-head
{color:#ff7900;font-weight:700;}#yiv4713350704 #yiv4713350704ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv4713350704 #yiv4713350704ygrp-sponsor
#yiv4713350704ov li a {font-size:130%;text-decoration:none;}#yiv4713350704
#yiv4713350704ygrp-sponsor #yiv4713350704ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4713350704
#yiv4713350704ygrp-sponsor #yiv4713350704ov ul {margin:0;padding:0 0 0
8px;}#yiv4713350704 #yiv4713350704ygrp-text
{font-family:Georgia;}#yiv4713350704 #yiv4713350704ygrp-text p {margin:0 0 1em
0;}#yiv4713350704 #yiv4713350704ygrp-text tt {font-size:120%;}#yiv4713350704
#yiv4713350704ygrp-vital ul li:last-child {border-right:none
!important;}#yiv4713350704
