Desember 8, 2010
PEMBERITAHUAN
berhubung karyawan bagiYan Quality Control sedang demo 🙂 … file FormControls.xls pada artikel ini yang udah di upload ndak melaluli prosedur penyortiran sebagEmana mUstinya ( alEsan yang mengada-ada 👿 )… ada kesalahan kode pada macro untuk menghapus record dari tabel … bagi yang terlanjur donlot sebelum post ini nongol silahkan kode macro untuk button HAPUS diganti yang seperti ini … yang beda cuman di baris yang nomer duWa (2) … selebihnya sama aja … ato donlot ulangseperti biasa jugak bisa udah saya apdet filenya … gitu aja koq refooooot 🙂
salam MDLMDL ………. 😎
bingung cara downloadnya ??Baca aja halaman download dengan klik icon di samping |
|
feed , email and my social media        |
| 1 | Sub hapus() |
| 2 | Sheets(“Sheet2”).Rows(Range(“nomr”)).Delete |
| 3 | Sheets(“sheet1”).Shapes(“SBH”).ControlFormat.Max = Sheets(“sheet1”).Shapes(“SBH”).ControlFormat.Max – 1 |
| 4 | Sheets(“sheet1”).Shapes(“SBV”).ControlFormat.Max = Sheets(“sheet1”).Shapes(“SBH”).ControlFormat.Max |
| 5 | repres |
| 6 | MsgBox “data telah dihapus”, vbInformation |
| 7 | End Sub |
Iklan
BIKIN OFFICE JADUL BISA BUKA EDIT DAN SIMPEN FILE OFFICE 2007 DAN 2010 PAKE MSO COMPATIBILITY PACK
BIKIN APLIKASI PERSEDIAAN PAKE EXCEL
CARA MEMBUAT DATA VALIDATION LIST EXCEL 2 KOLOM [MACRO VBA EXCEL TUTORIAL SERIES] – LANJUTAN
15 Comments
Jika sOdara menemukan sesuatu yang bermanpaat di marih .. atau pengen kasih masukan .... silahkan kasih komennya
This site uses Akismet to reduce spam. Learn how your comment data is processed.
1 Sub hapus()
2 Sheets(“Sheet2″).Rows(Range(“nomr”)).Delete
3 Sheets(“sheet1″).Shapes(“SBH”).ControlFormat.Max = Sheets(“sheet1″).Shapes(“SBH”).ControlFormat.Max – 1
4 Sheets(“sheet1″).Shapes(“SBV”).ControlFormat.Max = Sheets(“sheet1″).Shapes(“SBH”).ControlFormat.Max
5 repres
6 MsgBox “data telah dihapus”, vbInformation
7 End Sub
#######
kalo sya buat formula excel digabung formulanya ikut hilang mohon bantuannya agar formulanya tidak ikut hilang…. thx…
maksudnya apa nih dengan kata “digabung” apakah yang dimaksud “merge cell” ❓ kalau merge cell memang hanya isi cell “upper-left most” yang akan dipakai
Some companies even offer SR-22 filings for non-owners. You could serve jail time,
lose your license or be ordered by the court to do community service.
When shopping for insurance, keep in mind that an insurance agent does not necessarily know that an SR-22
filing is required unless a client specifically asks for one.
We stumbled over here by a different web page and thought I might check
things out. I like what I see so i am just following you.
Look forward to going over your web page for a second time.
Hi, after reading this remarkable article i am also glad to share my experience here with colleagues.
Yes! Finally someone writes about sr22 Wichita.
Hey just wanted to give you a quick heads up. The words in your article seem to be running
off the screen in Ie. I’m not sure if this is a formatting
issue or something to do with web browser compatibility but I figured I’d post to let you
know. The design and style look great though! Hope you get the problem
fixed soon. Cheers
When I originally commented I clicked the “Notify me when new comments are added” checkbox
and now each time a comment is added I get several e-mails with the same comment.
Is there any way you can remove me from that service?
Thank you!
whoah this weblog is magnificent i really like studying your posts.
Stay up the good work! You already know, a lot of individuals are searching around for this information, you could
aid them greatly.
There’s definately a great deal to know about this topic.
I really like all the points you have made.
This blog was… how do you say it? Relevant!! Finally I’ve found something that helped me.
Many thanks!
My spouse and I stumbled over here from a different page and thought I might as
well check things out. I like what I see so now
i’m following you. Look forward to going over your web page
yet again.
Say for example, you are holding Q-3 of spades in middle position.
Their insurance needs of a recreational vehicle recreational vehicle, a recreational vehicle insurance is not the same as auto insurance.
Without lots of practice you can watch and get a feel fro who has what cards by watching them look at the cards.
This web sire reawlly has all tthe information annd facts
I needed about his subject and didn’t know who to ask.
This website was… how do I say it? Relevant!! Finally I have
found something that helped me. Appreciate it!