cara yg ini, berlaku buat macro vba nya ka?
Pada tanggal Rab, 17 Okt 2018 pukul 08.29 Agus [email protected] [belajar-excel] <[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] [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]> <[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 > <[email protected]?subject=Re%3A%20%5Bbelajar-excel%5D%20Macro%20VBA%20%5B1%20Attachment%5D> > • Reply to group > <[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. > ------------------------------ > . > > > >
