Untuk form excel cara nya :
Klik view -> toolbars -> forms, setelah itu klik combo box, kemudian klik kanan combo box nya pilih format control, kemudian pilih tab control isi input range dan isi cell link (untuk value dari hasil yg di pilih.
Untuk form vb nya :
Klik view -> toolbars -> forms,
Pilih combo box, kemudian klik kanan pilih properties, kemudian isi listfillrange nya dengan range data kamu (misalnya $f$4:$f$7), kemudian isi linked cellnya dengan cell tertentu misalnya $g$5. Setelahh itu close properties window, dan exit design mode (yg gambar penggaris segitiga & pensil).
Semoga membantu.
Sent from my AXIS Worry Free BlackBerry® smartphone
-----Original Message-----
From: gnotowid@yahoo.com
Sender: XL-mania@yahoogroups.com
Date: Tue, 23 Nov 2010 15:55:21
To: <XL-mania@yahoogroups.com>
Reply-To: XL-mania@yahoogroups.com
Subject: ]] XL-mania [[ Combo Box di Form VB excel
Dear XL-Mania,
Ada yg bs sharing coding utk VB Excel Combo Box yg value/list nya berdasarkan range di salah satu sheet excel ?
Misalkan dari sheet1 dengan range A2:A5
Thank You
-G-
Sent from my BlackBerry®
powered by Sinyal Kuat INDOSAT
------------------------------------
+-:: XL-mania ::::::::::::::::::::----------------------------------+
| uaaaaaaa.... momods mau pulang cepet hari ini.... |
| http://www.facebook.com/group.php?gid=37671048001&ref=mf |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message, melecehkan, tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan winzip jika perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/ |
+-------------------------------------------------------------------+
| Berikan testimoni di : http://www.friendster.com/xlmania atau... |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html |
+-------------------------------------------------------------------+
| Message lama ada di : |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id] |
| http://www.mail-archive.com/xl-mania@yahoogroups.com |
+-------------------------------------------------------------------+Yahoo! Groups Links
------------------------------------
+-:: XL-mania ::::::::::::::::::::----------------------------------+
| uaaaaaaa.... momods mau pulang cepet hari ini.... |
| http://www.facebook.com/group.php?gid=37671048001&ref=mf |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message, melecehkan, tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan winzip jika perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/ |
+-------------------------------------------------------------------+
| Berikan testimoni di : http://www.friendster.com/xlmania atau... |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html |
+-------------------------------------------------------------------+
| Message lama ada di : |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id] |
| http://www.mail-archive.com/xl-mania@yahoogroups.com |
+-------------------------------------------------------------------+Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/XL-mania/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/XL-mania/join
(Yahoo! ID required)
<*> To change settings via email:
XL-mania-digest@yahoogroups.com
XL-mania-fullfeatured@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
XL-mania-unsubscribe@yahoogroups.com
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
Nenhum comentário:
Postar um comentário