terima kasih Mr. Kid atas pelajarannya
On Tuesday, July 26, 2016 9:27 AM, "'Mr. Kid' [email protected]
[belajar-excel]" <[email protected]> wrote:
Dear BeExceller,
Mau kenal dengan controls yang bisa digunakan di dalam worksheet ?
Jenis controls yang bisa digunakan di dalam worksheet adalah
1. Form2 Controls alias controls bawaan Office
2. ActiveX Controls
Form2 Controls digunakan di dalam worksheet. Mudah digunakan dan diatur tanpa
VBA walaupun memiliki banyak keterbatasan. Salah satu keterbatasannya adalah
relatif sulit diatur dengan VBA. Salah satu kelebihannya adalah bisa linked
dengan cells secara dinamis tanpa VBA.
Controls dalam jenis Form2 controls ini antara lain :
1. List Box yang terkadang juga disebut sebagai Drop Down List
(bukan ListBox, karena ListBox adalah jenis ActiveX controls yang mudah diatur
denga VBA)
2. Combo Box yang lebih dikenal dengan Drop Down
(bukan ComboBox, karena ComboBox adalah jenis ActiveX Controls yang mudah
diatur dengan VBA)
File yang ada disini berisi 2 buah Form2 Controls di atas.
Semoga bermanfaat.
Regards,
Kid
#yiv4291504417 #yiv4291504417 -- #yiv4291504417ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4291504417
#yiv4291504417ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4291504417
#yiv4291504417ygrp-mkp #yiv4291504417hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4291504417 #yiv4291504417ygrp-mkp #yiv4291504417ads
{margin-bottom:10px;}#yiv4291504417 #yiv4291504417ygrp-mkp .yiv4291504417ad
{padding:0 0;}#yiv4291504417 #yiv4291504417ygrp-mkp .yiv4291504417ad p
{margin:0;}#yiv4291504417 #yiv4291504417ygrp-mkp .yiv4291504417ad a
{color:#0000ff;text-decoration:none;}#yiv4291504417 #yiv4291504417ygrp-sponsor
#yiv4291504417ygrp-lc {font-family:Arial;}#yiv4291504417
#yiv4291504417ygrp-sponsor #yiv4291504417ygrp-lc #yiv4291504417hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4291504417
#yiv4291504417ygrp-sponsor #yiv4291504417ygrp-lc .yiv4291504417ad
{margin-bottom:10px;padding:0 0;}#yiv4291504417 #yiv4291504417actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4291504417
#yiv4291504417activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4291504417
#yiv4291504417activity span {font-weight:700;}#yiv4291504417
#yiv4291504417activity span:first-child
{text-transform:uppercase;}#yiv4291504417 #yiv4291504417activity span a
{color:#5085b6;text-decoration:none;}#yiv4291504417 #yiv4291504417activity span
span {color:#ff7900;}#yiv4291504417 #yiv4291504417activity span
.yiv4291504417underline {text-decoration:underline;}#yiv4291504417
.yiv4291504417attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4291504417 .yiv4291504417attach div a
{text-decoration:none;}#yiv4291504417 .yiv4291504417attach img
{border:none;padding-right:5px;}#yiv4291504417 .yiv4291504417attach label
{display:block;margin-bottom:5px;}#yiv4291504417 .yiv4291504417attach label a
{text-decoration:none;}#yiv4291504417 blockquote {margin:0 0 0
4px;}#yiv4291504417 .yiv4291504417bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4291504417
.yiv4291504417bold a {text-decoration:none;}#yiv4291504417 dd.yiv4291504417last
p a {font-family:Verdana;font-weight:700;}#yiv4291504417 dd.yiv4291504417last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4291504417
dd.yiv4291504417last p span.yiv4291504417yshortcuts
{margin-right:0;}#yiv4291504417 div.yiv4291504417attach-table div div a
{text-decoration:none;}#yiv4291504417 div.yiv4291504417attach-table
{width:400px;}#yiv4291504417 div.yiv4291504417file-title a, #yiv4291504417
div.yiv4291504417file-title a:active, #yiv4291504417
div.yiv4291504417file-title a:hover, #yiv4291504417 div.yiv4291504417file-title
a:visited {text-decoration:none;}#yiv4291504417 div.yiv4291504417photo-title a,
#yiv4291504417 div.yiv4291504417photo-title a:active, #yiv4291504417
div.yiv4291504417photo-title a:hover, #yiv4291504417
div.yiv4291504417photo-title a:visited {text-decoration:none;}#yiv4291504417
div#yiv4291504417ygrp-mlmsg #yiv4291504417ygrp-msg p a
span.yiv4291504417yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4291504417
.yiv4291504417green {color:#628c2a;}#yiv4291504417 .yiv4291504417MsoNormal
{margin:0 0 0 0;}#yiv4291504417 o {font-size:0;}#yiv4291504417
#yiv4291504417photos div {float:left;width:72px;}#yiv4291504417
#yiv4291504417photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv4291504417
#yiv4291504417photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4291504417
#yiv4291504417reco-category {font-size:77%;}#yiv4291504417
#yiv4291504417reco-desc {font-size:77%;}#yiv4291504417 .yiv4291504417replbq
{margin:4px;}#yiv4291504417 #yiv4291504417ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4291504417 #yiv4291504417ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4291504417
#yiv4291504417ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4291504417
#yiv4291504417ygrp-mlmsg select, #yiv4291504417 input, #yiv4291504417 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4291504417
#yiv4291504417ygrp-mlmsg pre, #yiv4291504417 code {font:115%
monospace;}#yiv4291504417 #yiv4291504417ygrp-mlmsg *
{line-height:1.22em;}#yiv4291504417 #yiv4291504417ygrp-mlmsg #yiv4291504417logo
{padding-bottom:10px;}#yiv4291504417 #yiv4291504417ygrp-msg p a
{font-family:Verdana;}#yiv4291504417 #yiv4291504417ygrp-msg
p#yiv4291504417attach-count span {color:#1E66AE;font-weight:700;}#yiv4291504417
#yiv4291504417ygrp-reco #yiv4291504417reco-head
{color:#ff7900;font-weight:700;}#yiv4291504417 #yiv4291504417ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv4291504417 #yiv4291504417ygrp-sponsor
#yiv4291504417ov li a {font-size:130%;text-decoration:none;}#yiv4291504417
#yiv4291504417ygrp-sponsor #yiv4291504417ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4291504417
#yiv4291504417ygrp-sponsor #yiv4291504417ov ul {margin:0;padding:0 0 0
8px;}#yiv4291504417 #yiv4291504417ygrp-text
{font-family:Georgia;}#yiv4291504417 #yiv4291504417ygrp-text p {margin:0 0 1em
0;}#yiv4291504417 #yiv4291504417ygrp-text tt {font-size:120%;}#yiv4291504417
#yiv4291504417ygrp-vital ul li:last-child {border-right:none
!important;}#yiv4291504417
