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 [email protected] [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 <[email protected]>
------------------------------------------------------------------------
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:[email protected]?subject=Re%3A%20%5Bbelajar-excel%5D%20Macro%20VBA%20%5B1%20Attachment%5D>
• Reply to group
<mailto:[email protected]?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:
[email protected]
posting ke milis, kirimkan ke: [email protected]
berkunjung ke web milis :
http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran :
http://www.mail-archive.com/[email protected]/
atau (sejak 25-Apr-2011) bisa juga di :
http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: [email protected]
keluar dari membership milis (UnSubscribe), kirim mail kosong ke :
[email protected]
---------------------------------------------------------------------
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:[email protected]?subject=Unsubscribe>
• Terms of Use <https://info.yahoo.com/legal/us/yahoo/utos/terms/>
SPONSORED LINKS
.
