Cara pakai vba:
|Cells.Find|( |_What_| , |_After_| , |_LookIn_| , |_LookAt_| ,
|_SearchOrder_| , |_SearchDirection_| , |_MatchCase_| , |_MatchByte_| ,
|_SearchFormat_| )
panduan lengkapnya ada di sini
<https://docs.microsoft.com/en-us/office/vba/api/excel.range.find>
Regard
Agus
On 10/17/2018 13:28, Febri Ulan [email protected] [belajar-excel] wrote:
cara yg ini, berlaku buat macro vba nya ka?
Pada tanggal Rab, 17 Okt 2018 pukul 08.29 Agus [email protected]
<mailto:[email protected]> [belajar-excel]
<[email protected]
<mailto:[email protected]>> menulis:
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]
<mailto:[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]>
<mailto:[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.
------------------------------------------------------------------------
.
