Terima kasih atas solusinya, kini dropDownku telah berjalan sebagaimana yang
diharapkan...
On Sunday, March 22, 2015 9:53 PM, "Toby kenzo [email protected]
[belajar-excel]" <[email protected]> wrote:
| Dear mas Haris,sorry filenya ketinggalan.TerimaKasih.Sent from Yahoo Mail on
Android |
From: ris ha [email protected] [belajar-excel]
<[email protected]>;
To: [email protected] <[email protected]>;
Subject: Re: Bls: Bls: Bls: [belajar-excel] Setting ComboBox id Ribbon
Sent: Thu, Mar 19, 2015 4:26:19 AM
| setelah seharian nyari2, ternyata g nemu cara agar list yg kita pilih
pada dropdown bisa langsung membuka sheets yg kita tuju, mohon bantuannya donk
para master semua
SalamHaris
On Wednesday, March 18, 2015 3:21 PM, "Toby kenzo [email protected]
[belajar-excel]" <[email protected]> wrote:
Dear Pak Haris, Bisa pak, tinggal di tambahkan formula di modulnya saja
pak. TerimaKasih.
Pada Rabu, 18 Maret 2015 14:32, "ris ha [email protected]
[belajar-excel]" <[email protected]> menulis:
mantap pak, tapi, saya jadi ada pertanyaan, terkait drop down pd file
Ron_DropDown
kira2, kalo kita memilih item (misal item 8) maka Msg bisa langsung keluar
tanpa harus mengklik tombol Value Selected Item.
On Wednesday, March 18, 2015 10:38 AM, "Toby kenzo [email protected]
[belajar-excel]" <[email protected]> wrote:
Dear Mas Haris, Ini ada contoh yang saya ambil dari internet, semoga kita
bisa belajar sama-sama.Bisa di check contoh ini mengunkan CustomUI editor 2007
atau 2010-2013 dengan menggunakan CustomUi Editor yang sudah mas Haris Install
di computer.Contoh ini menggunakan Dropdown, jika mau terus belajar, mas Haris
bias kunjungi websitenya "www.rondebruin.nl" Semoga membantu. TerimaKasih,
Pada Rabu, 18 Maret 2015 9:52, "ris ha [email protected]
[belajar-excel]" <[email protected]> menulis:
Sdh pak Toby, sudah saya install, sehingga saya bisa belajar setting
ribbon sendiri. cuman referensinya masih sangat terbatas yg berbahasa
indonesia, alhamdulillah ada milis Excel ini, sehingga bisa banyak belajar dari
para Jawara Excel disini
On Wednesday, March 18, 2015 9:30 AM, "Toby kenzo [email protected]
[belajar-excel]" <[email protected]> wrote:
Dear Mas Haris, Apakah CustomUI Editor sudah terinstal di computer mas
Haris..? TerimaKasih.
Pada Selasa, 17 Maret 2015 14:56, "ris ha [email protected]
[belajar-excel]" <[email protected]> menulis:
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
|
#yiv7869407845 #yiv7869407845 -- #yiv7869407845ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7869407845
#yiv7869407845ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7869407845
#yiv7869407845ygrp-mkp #yiv7869407845hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7869407845 #yiv7869407845ygrp-mkp #yiv7869407845ads
{margin-bottom:10px;}#yiv7869407845 #yiv7869407845ygrp-mkp .yiv7869407845ad
{padding:0 0;}#yiv7869407845 #yiv7869407845ygrp-mkp .yiv7869407845ad p
{margin:0;}#yiv7869407845 #yiv7869407845ygrp-mkp .yiv7869407845ad a
{color:#0000ff;text-decoration:none;}#yiv7869407845 #yiv7869407845ygrp-sponsor
#yiv7869407845ygrp-lc {font-family:Arial;}#yiv7869407845
#yiv7869407845ygrp-sponsor #yiv7869407845ygrp-lc #yiv7869407845hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7869407845
#yiv7869407845ygrp-sponsor #yiv7869407845ygrp-lc .yiv7869407845ad
{margin-bottom:10px;padding:0 0;}#yiv7869407845 #yiv7869407845actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7869407845
#yiv7869407845activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7869407845
#yiv7869407845activity span {font-weight:700;}#yiv7869407845
#yiv7869407845activity span:first-child
{text-transform:uppercase;}#yiv7869407845 #yiv7869407845activity span a
{color:#5085b6;text-decoration:none;}#yiv7869407845 #yiv7869407845activity span
span {color:#ff7900;}#yiv7869407845 #yiv7869407845activity span
.yiv7869407845underline {text-decoration:underline;}#yiv7869407845
.yiv7869407845attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7869407845 .yiv7869407845attach div a
{text-decoration:none;}#yiv7869407845 .yiv7869407845attach img
{border:none;padding-right:5px;}#yiv7869407845 .yiv7869407845attach label
{display:block;margin-bottom:5px;}#yiv7869407845 .yiv7869407845attach label a
{text-decoration:none;}#yiv7869407845 blockquote {margin:0 0 0
4px;}#yiv7869407845 .yiv7869407845bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7869407845
.yiv7869407845bold a {text-decoration:none;}#yiv7869407845 dd.yiv7869407845last
p a {font-family:Verdana;font-weight:700;}#yiv7869407845 dd.yiv7869407845last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7869407845
dd.yiv7869407845last p span.yiv7869407845yshortcuts
{margin-right:0;}#yiv7869407845 div.yiv7869407845attach-table div div a
{text-decoration:none;}#yiv7869407845 div.yiv7869407845attach-table
{width:400px;}#yiv7869407845 div.yiv7869407845file-title a, #yiv7869407845
div.yiv7869407845file-title a:active, #yiv7869407845
div.yiv7869407845file-title a:hover, #yiv7869407845 div.yiv7869407845file-title
a:visited {text-decoration:none;}#yiv7869407845 div.yiv7869407845photo-title a,
#yiv7869407845 div.yiv7869407845photo-title a:active, #yiv7869407845
div.yiv7869407845photo-title a:hover, #yiv7869407845
div.yiv7869407845photo-title a:visited {text-decoration:none;}#yiv7869407845
div#yiv7869407845ygrp-mlmsg #yiv7869407845ygrp-msg p a
span.yiv7869407845yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7869407845
.yiv7869407845green {color:#628c2a;}#yiv7869407845 .yiv7869407845MsoNormal
{margin:0 0 0 0;}#yiv7869407845 o {font-size:0;}#yiv7869407845
#yiv7869407845photos div {float:left;width:72px;}#yiv7869407845
#yiv7869407845photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv7869407845
#yiv7869407845photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7869407845
#yiv7869407845reco-category {font-size:77%;}#yiv7869407845
#yiv7869407845reco-desc {font-size:77%;}#yiv7869407845 .yiv7869407845replbq
{margin:4px;}#yiv7869407845 #yiv7869407845ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7869407845 #yiv7869407845ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7869407845
#yiv7869407845ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7869407845
#yiv7869407845ygrp-mlmsg select, #yiv7869407845 input, #yiv7869407845 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7869407845
#yiv7869407845ygrp-mlmsg pre, #yiv7869407845 code {font:115%
monospace;}#yiv7869407845 #yiv7869407845ygrp-mlmsg *
{line-height:1.22em;}#yiv7869407845 #yiv7869407845ygrp-mlmsg #yiv7869407845logo
{padding-bottom:10px;}#yiv7869407845 #yiv7869407845ygrp-msg p a
{font-family:Verdana;}#yiv7869407845 #yiv7869407845ygrp-msg
p#yiv7869407845attach-count span {color:#1E66AE;font-weight:700;}#yiv7869407845
#yiv7869407845ygrp-reco #yiv7869407845reco-head
{color:#ff7900;font-weight:700;}#yiv7869407845 #yiv7869407845ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7869407845 #yiv7869407845ygrp-sponsor
#yiv7869407845ov li a {font-size:130%;text-decoration:none;}#yiv7869407845
#yiv7869407845ygrp-sponsor #yiv7869407845ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7869407845
#yiv7869407845ygrp-sponsor #yiv7869407845ov ul {margin:0;padding:0 0 0
8px;}#yiv7869407845 #yiv7869407845ygrp-text
{font-family:Georgia;}#yiv7869407845 #yiv7869407845ygrp-text p {margin:0 0 1em
0;}#yiv7869407845 #yiv7869407845ygrp-text tt {font-size:120%;}#yiv7869407845
#yiv7869407845ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7869407845
