[belajar-excel] Digest Number 4630

Milis Belajar Microsoft Excel Group

1 Message

Digest #4630

1a

Re: Macro VBA by "Agus"

Message

1a

Re: Macro VBA

Thu Oct 18, 2018 6:00 pm (PDT) . Posted by:

"Agus"

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 febriulan26@gmail.com [belajar-excel] wrote:
> cara yg ini, berlaku buat macro vba nya ka?
>
>
> Pada tanggal Rab, 17 Okt 2018 pukul 08.29 Agus nangagus@gmail.com
> <mailto:nangagus@gmail.com> [belajar-excel]
> <belajar-excel@yahoogroups.com
> <mailto:belajar-excel@yahoogroups..com>> 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 febriulan26@gmail.com
> <mailto:febriulan26@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 <febriulan26@gmail.com>
>> <mailto:febriulan26@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:febriulan26@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.
>> ----------------------------------------------------------
>> .
>>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (15) . Top ^

============================================================
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-subscribe@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-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

Visit Your Group

• Privacy • Unsubscribe • Terms of Use