Dear Febri, lebih mudah begini:
1. Ketik Ctrl +F
2. Ubah Whithin = Workbook
3. Ubah Look in = Values
4. Ketik yang akan dicari pada Find what
5. Klik Find All
Regard
Agus
on 10/16/2018 16:54, Febri Ulan febriula...@gmail.com [belajar-excel] wrote:
terimakasih lagi kak agus, nnti coba fbri terapin..
mau nnya lagi boleh?
cara search menurut kategori, tapi data nya campuran (ada di sheet 2,
sheet 3, sheet 4) itu gmna kak?
misalkan :
sheet 1 : nama panggilan, perusahaan,alamat, kota
sheet 2 : no. tlp, no.ktp, kota, keterangan
sheet 3 : nama lengkap, tanggal lahir, kota,
nah febri mau,
search combobox menurut 'kota'
tapi semua data yang ada di sheet 1 & 2 & 3 muncul di listbox sesuai
dengan kategori searching nya kak..
boelh di bantu lagi ka?
maaf ya kak, nnya terus. soalnya bru belajar pake VBA macro kak, dn
bru nyentuh juga bahasa VB
.___
------------------------------------------------------------------------
Posted by: Febri Ulan <febriula...@gmail.com>
------------------------------------------------------------------------
Reply via web post
<https://groups.yahoo.com/neo/groups/belajar-excel/conversations/messages/44909;_ylc=X3oDMTJycmVlY2s5BF9TAzk3MzU5NzE0BGdycElkAzIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRtc2dJZAM0NDkwOQRzZWMDZnRyBHNsawNycGx5BHN0aW1lAzE1Mzk2ODk3MTQ-?act=reply&messageNum=44909>
• Reply to sender
<mailto:febriula...@gmail.com?subject=Re%3A%20%5Bbelajar-excel%5D%20Macro%20VBA%20%5B1%20Attachment%5D>
• Reply to group
<mailto:belajar-excel@yahoogroups.com?subject=Re%3A%20%5Bbelajar-excel%5D%20Macro%20VBA%20%5B1%20Attachment%5D>
• Start a New Topic
<https://groups.yahoo.com/neo/groups/belajar-excel/conversations/newtopic;_ylc=X3oDMTJmOGlsdGEwBF9TAzk3MzU5NzE0BGdycElkAzIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRzZWMDZnRyBHNsawNudHBjBHN0aW1lAzE1Mzk2ODk3MTQ->
• Messages in this topic
<https://groups.yahoo.com/neo/groups/belajar-excel/conversations/topics/44817;_ylc=X3oDMTM3dmRkMDc5BF9TAzk3MzU5NzE0BGdycElkAzIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRtc2dJZAM0NDkwOQRzZWMDZnRyBHNsawN2dHBjBHN0aW1lAzE1Mzk2ODk3MTQEdHBjSWQDNDQ4MTc->
(10)
------------------------------------------------------------------------
Have you tried the highest rated email app? <https://yho.com/1wwmgg>
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated
email app on the market. What are you waiting for? Now you can access
all your inboxes (Gmail, Outlook, AOL and more) in one place. Never
delete an email again with 1000GB of free cloud storage.
------------------------------------------------------------------------
============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke:
belajar-excel-subscr...@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis :
http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran :
http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di :
http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-ow...@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke :
belajar-excel-unsubscr...@yahoogroups.com
---------------------------------------------------------------------
Visit Your Group
<https://groups.yahoo.com/neo/groups/belajar-excel/info;_ylc=X3oDMTJmM2o1NGJiBF9TAzk3MzU5NzE0BGdycElkAzIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRzZWMDdnRsBHNsawN2Z2hwBHN0aW1lAzE1Mzk2ODk3MTQ->
Yahoo! Groups
<https://groups.yahoo.com/neo;_ylc=X3oDMTJlMG9mMW9nBF9TAzk3NDc2NTkwBGdycElkAzIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRzZWMDZnRyBHNsawNnZnAEc3RpbWUDMTUzOTY4OTcxOA-->
• Privacy
<https://info.yahoo.com/privacy/us/yahoo/groups/details.html> •
Unsubscribe
<mailto:belajar-excel-unsubscr...@yahoogroups.com?subject=Unsubscribe>
• Terms of Use <https://info.yahoo.com/legal/us/yahoo/utos/terms/>
SPONSORED LINKS
.
