Terim kasih pak, kesulitan selanjutnya adalah pertanyaan point 4, saya udah
dapat di
Questions on customising the ribbon - Nick Hodge's Excel Blog - Excel User Group
| |
| | | | | | | |
| Questions on customising the ribbon - Nick Hodge's Excel...Nick Hodges Excel
Blog, information on Microsoft Excel |
| |
| View on excelusergroup.org | Preview by Yahoo |
| |
| |
tapi saya g maksud, saya praktekan, susah banget pak, mohon pencerahannya
SalamHaris
On Tuesday, March 17, 2015 1:59 PM, "Nang Agus [email protected]
[belajar-excel]" <[email protected]> wrote:
Untuk panjang ComboBox yang hanya 2 karakter dapat ditambahkan:
sizeString="WW"
pada properti combobox,
untuk memasukan tanggal, buat module:
Sub AturTgl(control As IRibbonControl, text As String)
Range("I3") = text
End Sub
salam
2015-03-16 13:13 GMT+07:00 ris ha [email protected] [belajar-excel]
<[email protected]>:
Assalamu'alaikum.
Mohon bantuannya para master excel semua. saya udah searcing di google, tp g
ketemu juga.
Bagaimana mensetting ComboBox id Ribbon yg kita buat sendiri. Cakupan Setting
adalah (file terlampir)
1. Panjang comboBox, Kalo kita lihat size font pada TabHome, maka panjang
comboBox menjadi kecil mengikuti isi, bagaimana mensettingnya?2. Menghubungkan
comboBox dengan cell. Bagaimana caranya menghubungkan tgl pada TabStart ke cell
tgl di sheet Help?3. Menghubungkan comboBox dengan data pekerjaan4. Membatasi
view pada item comboBox. Pada combo Tgl di TabStart, saya telah mengisi 1 s/d
20 ternyata ditampilkan semua, bagaimana cara membatasi viewnya? misal 1 s/d 5,
selanjutnya menggunakan scroll
Terima kasih atas solusinya
SalamHaris
#yiv4806328062 #yiv4806328062 -- #yiv4806328062ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4806328062
#yiv4806328062ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4806328062
#yiv4806328062ygrp-mkp #yiv4806328062hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4806328062 #yiv4806328062ygrp-mkp #yiv4806328062ads
{margin-bottom:10px;}#yiv4806328062 #yiv4806328062ygrp-mkp .yiv4806328062ad
{padding:0 0;}#yiv4806328062 #yiv4806328062ygrp-mkp .yiv4806328062ad p
{margin:0;}#yiv4806328062 #yiv4806328062ygrp-mkp .yiv4806328062ad a
{color:#0000ff;text-decoration:none;}#yiv4806328062 #yiv4806328062ygrp-sponsor
#yiv4806328062ygrp-lc {font-family:Arial;}#yiv4806328062
#yiv4806328062ygrp-sponsor #yiv4806328062ygrp-lc #yiv4806328062hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4806328062
#yiv4806328062ygrp-sponsor #yiv4806328062ygrp-lc .yiv4806328062ad
{margin-bottom:10px;padding:0 0;}#yiv4806328062 #yiv4806328062actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4806328062
#yiv4806328062activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4806328062
#yiv4806328062activity span {font-weight:700;}#yiv4806328062
#yiv4806328062activity span:first-child
{text-transform:uppercase;}#yiv4806328062 #yiv4806328062activity span a
{color:#5085b6;text-decoration:none;}#yiv4806328062 #yiv4806328062activity span
span {color:#ff7900;}#yiv4806328062 #yiv4806328062activity span
.yiv4806328062underline {text-decoration:underline;}#yiv4806328062
.yiv4806328062attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4806328062 .yiv4806328062attach div a
{text-decoration:none;}#yiv4806328062 .yiv4806328062attach img
{border:none;padding-right:5px;}#yiv4806328062 .yiv4806328062attach label
{display:block;margin-bottom:5px;}#yiv4806328062 .yiv4806328062attach label a
{text-decoration:none;}#yiv4806328062 blockquote {margin:0 0 0
4px;}#yiv4806328062 .yiv4806328062bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4806328062
.yiv4806328062bold a {text-decoration:none;}#yiv4806328062 dd.yiv4806328062last
p a {font-family:Verdana;font-weight:700;}#yiv4806328062 dd.yiv4806328062last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4806328062
dd.yiv4806328062last p span.yiv4806328062yshortcuts
{margin-right:0;}#yiv4806328062 div.yiv4806328062attach-table div div a
{text-decoration:none;}#yiv4806328062 div.yiv4806328062attach-table
{width:400px;}#yiv4806328062 div.yiv4806328062file-title a, #yiv4806328062
div.yiv4806328062file-title a:active, #yiv4806328062
div.yiv4806328062file-title a:hover, #yiv4806328062 div.yiv4806328062file-title
a:visited {text-decoration:none;}#yiv4806328062 div.yiv4806328062photo-title a,
#yiv4806328062 div.yiv4806328062photo-title a:active, #yiv4806328062
div.yiv4806328062photo-title a:hover, #yiv4806328062
div.yiv4806328062photo-title a:visited {text-decoration:none;}#yiv4806328062
div#yiv4806328062ygrp-mlmsg #yiv4806328062ygrp-msg p a
span.yiv4806328062yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4806328062
.yiv4806328062green {color:#628c2a;}#yiv4806328062 .yiv4806328062MsoNormal
{margin:0 0 0 0;}#yiv4806328062 o {font-size:0;}#yiv4806328062
#yiv4806328062photos div {float:left;width:72px;}#yiv4806328062
#yiv4806328062photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv4806328062
#yiv4806328062photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4806328062
#yiv4806328062reco-category {font-size:77%;}#yiv4806328062
#yiv4806328062reco-desc {font-size:77%;}#yiv4806328062 .yiv4806328062replbq
{margin:4px;}#yiv4806328062 #yiv4806328062ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4806328062 #yiv4806328062ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4806328062
#yiv4806328062ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4806328062
#yiv4806328062ygrp-mlmsg select, #yiv4806328062 input, #yiv4806328062 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4806328062
#yiv4806328062ygrp-mlmsg pre, #yiv4806328062 code {font:115%
monospace;}#yiv4806328062 #yiv4806328062ygrp-mlmsg *
{line-height:1.22em;}#yiv4806328062 #yiv4806328062ygrp-mlmsg #yiv4806328062logo
{padding-bottom:10px;}#yiv4806328062 #yiv4806328062ygrp-msg p a
{font-family:Verdana;}#yiv4806328062 #yiv4806328062ygrp-msg
p#yiv4806328062attach-count span {color:#1E66AE;font-weight:700;}#yiv4806328062
#yiv4806328062ygrp-reco #yiv4806328062reco-head
{color:#ff7900;font-weight:700;}#yiv4806328062 #yiv4806328062ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv4806328062 #yiv4806328062ygrp-sponsor
#yiv4806328062ov li a {font-size:130%;text-decoration:none;}#yiv4806328062
#yiv4806328062ygrp-sponsor #yiv4806328062ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4806328062
#yiv4806328062ygrp-sponsor #yiv4806328062ov ul {margin:0;padding:0 0 0
8px;}#yiv4806328062 #yiv4806328062ygrp-text
{font-family:Georgia;}#yiv4806328062 #yiv4806328062ygrp-text p {margin:0 0 1em
0;}#yiv4806328062 #yiv4806328062ygrp-text tt {font-size:120%;}#yiv4806328062
#yiv4806328062ygrp-vital ul li:last-child {border-right:none
!important;}#yiv4806328062
