Hai Roni,
Untuk membatasi data listBox, anda bisa membatasinya dengan menggunakan 
"ManagerName" untuk membatasi jumlah data yang akan di tampilkan, atau dengan 
fungsi Count untuk membatasi.
TerimaKasih. 

    Pada Kamis, 20 Oktober 2016 17:46, "[email protected] [belajar-excel]" 
<[email protected]> menulis:
 

     Dear All,
Mohon dibantu,
Menyesuaikan text pada saat kursor ditarik agar ruang kosong dibawah tidak 
tampil.Apa yang saya lakukan. Makasih

  #yiv9086022593 #yiv9086022593 -- #yiv9086022593ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9086022593 
#yiv9086022593ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9086022593 
#yiv9086022593ygrp-mkp #yiv9086022593hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv9086022593 #yiv9086022593ygrp-mkp #yiv9086022593ads 
{margin-bottom:10px;}#yiv9086022593 #yiv9086022593ygrp-mkp .yiv9086022593ad 
{padding:0 0;}#yiv9086022593 #yiv9086022593ygrp-mkp .yiv9086022593ad p 
{margin:0;}#yiv9086022593 #yiv9086022593ygrp-mkp .yiv9086022593ad a 
{color:#0000ff;text-decoration:none;}#yiv9086022593 #yiv9086022593ygrp-sponsor 
#yiv9086022593ygrp-lc {font-family:Arial;}#yiv9086022593 
#yiv9086022593ygrp-sponsor #yiv9086022593ygrp-lc #yiv9086022593hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9086022593 
#yiv9086022593ygrp-sponsor #yiv9086022593ygrp-lc .yiv9086022593ad 
{margin-bottom:10px;padding:0 0;}#yiv9086022593 #yiv9086022593actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9086022593 
#yiv9086022593activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9086022593
 #yiv9086022593activity span {font-weight:700;}#yiv9086022593 
#yiv9086022593activity span:first-child 
{text-transform:uppercase;}#yiv9086022593 #yiv9086022593activity span a 
{color:#5085b6;text-decoration:none;}#yiv9086022593 #yiv9086022593activity span 
span {color:#ff7900;}#yiv9086022593 #yiv9086022593activity span 
.yiv9086022593underline {text-decoration:underline;}#yiv9086022593 
.yiv9086022593attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv9086022593 .yiv9086022593attach div a 
{text-decoration:none;}#yiv9086022593 .yiv9086022593attach img 
{border:none;padding-right:5px;}#yiv9086022593 .yiv9086022593attach label 
{display:block;margin-bottom:5px;}#yiv9086022593 .yiv9086022593attach label a 
{text-decoration:none;}#yiv9086022593 blockquote {margin:0 0 0 
4px;}#yiv9086022593 .yiv9086022593bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9086022593 
.yiv9086022593bold a {text-decoration:none;}#yiv9086022593 dd.yiv9086022593last 
p a {font-family:Verdana;font-weight:700;}#yiv9086022593 dd.yiv9086022593last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9086022593 
dd.yiv9086022593last p span.yiv9086022593yshortcuts 
{margin-right:0;}#yiv9086022593 div.yiv9086022593attach-table div div a 
{text-decoration:none;}#yiv9086022593 div.yiv9086022593attach-table 
{width:400px;}#yiv9086022593 div.yiv9086022593file-title a, #yiv9086022593 
div.yiv9086022593file-title a:active, #yiv9086022593 
div.yiv9086022593file-title a:hover, #yiv9086022593 div.yiv9086022593file-title 
a:visited {text-decoration:none;}#yiv9086022593 div.yiv9086022593photo-title a, 
#yiv9086022593 div.yiv9086022593photo-title a:active, #yiv9086022593 
div.yiv9086022593photo-title a:hover, #yiv9086022593 
div.yiv9086022593photo-title a:visited {text-decoration:none;}#yiv9086022593 
div#yiv9086022593ygrp-mlmsg #yiv9086022593ygrp-msg p a 
span.yiv9086022593yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9086022593 
.yiv9086022593green {color:#628c2a;}#yiv9086022593 .yiv9086022593MsoNormal 
{margin:0 0 0 0;}#yiv9086022593 o {font-size:0;}#yiv9086022593 
#yiv9086022593photos div {float:left;width:72px;}#yiv9086022593 
#yiv9086022593photos div div {border:1px solid 
#666666;height:62px;overflow:hidden;width:62px;}#yiv9086022593 
#yiv9086022593photos div label 
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9086022593
 #yiv9086022593reco-category {font-size:77%;}#yiv9086022593 
#yiv9086022593reco-desc {font-size:77%;}#yiv9086022593 .yiv9086022593replbq 
{margin:4px;}#yiv9086022593 #yiv9086022593ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv9086022593 #yiv9086022593ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9086022593 
#yiv9086022593ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9086022593 
#yiv9086022593ygrp-mlmsg select, #yiv9086022593 input, #yiv9086022593 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9086022593 
#yiv9086022593ygrp-mlmsg pre, #yiv9086022593 code {font:115% 
monospace;}#yiv9086022593 #yiv9086022593ygrp-mlmsg * 
{line-height:1.22em;}#yiv9086022593 #yiv9086022593ygrp-mlmsg #yiv9086022593logo 
{padding-bottom:10px;}#yiv9086022593 #yiv9086022593ygrp-msg p a 
{font-family:Verdana;}#yiv9086022593 #yiv9086022593ygrp-msg 
p#yiv9086022593attach-count span {color:#1E66AE;font-weight:700;}#yiv9086022593 
#yiv9086022593ygrp-reco #yiv9086022593reco-head 
{color:#ff7900;font-weight:700;}#yiv9086022593 #yiv9086022593ygrp-reco 
{margin-bottom:20px;padding:0px;}#yiv9086022593 #yiv9086022593ygrp-sponsor 
#yiv9086022593ov li a {font-size:130%;text-decoration:none;}#yiv9086022593 
#yiv9086022593ygrp-sponsor #yiv9086022593ov li 
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9086022593 
#yiv9086022593ygrp-sponsor #yiv9086022593ov ul {margin:0;padding:0 0 0 
8px;}#yiv9086022593 #yiv9086022593ygrp-text 
{font-family:Georgia;}#yiv9086022593 #yiv9086022593ygrp-text p {margin:0 0 1em 
0;}#yiv9086022593 #yiv9086022593ygrp-text tt {font-size:120%;}#yiv9086022593 
#yiv9086022593ygrp-vital ul li:last-child {border-right:none 
!important;}#yiv9086022593 

   

Kirim email ke