Macro untuk Excel UserForm input pembayaran

Last updated on March 16th, 2021 at 06:07 pm

Contoh Pertama:
A. Mbak Inem membayar hutangnya sebesar Rp 3.000.000 tanpa perduli nomor invoice/nota-nya. Seperti yang terlihat pada gambar-5 pada halaman 1 topik ini, diketahui bahwa total hutang mbak ini adalah Rp 11.390.000. Jadi pada kasus seperti ini, yang digunakan adalah tombol Ketik Nilai Bayar, dimana nilai tiga juta ini diketik tanpa titik tanpa koma. Seperti pada animasi gambar-6 dibawah ini.

test run macro userform excel invoice piutang bayar
gambar-6

Seperti yang terlihat pada animasi gambar-6 diatas, kode menyalin dua buah nomor nota dari UserForm ke baris dibawah kolom NOTA halaman BAYAR. Proses kode dalam hal ini adalah mengambil mulai dari nomor nota tertua.

test run input userform excel macro untuk hutang bayar
gambar-7

Terlihat pada gambar-7, bahwa dua nomor nota yang diambil kode tsb adalah nota bulan Februari. Pada halaman BAYAR, nota yang pertama (PA-200224018) senilai Rp 1.816.600 dibayar penuh. Nota yang kedua (PB-200228006) tidak dibayar penuh, melainkan dibayar sebesar Rp 1.183.400. Total utang mbak Inem nanti akan menjadi Rp 8.390.000, dimana nomor nota PB-200228006 nya tidak lagi senilai Rp 1.767.100, melainkan senilai Rp 1.767.100 – Rp 1.183.400 = Rp 583.700,-

Contoh Kedua:
Ko Ahok membayar hutang-nya sebesar Rp 882.000. Dia bilang ke pak Adi : “Pak, ini saya bayar satu nota yang bulan Januari 2021 dulu ya. Nota yang paling kecil nilainya, yakni nota PB-210126008. Lagi bokek soalnya nih”. Pada kasus seperti ini, maka yang digunakan adalah tombol Nota Dipilih. Seperti pada gambar-8 dibawah ini.

Total utang ko Ahok nanti menjadi Rp 20.023.500 – Rp 882.000 = Rp 19.141.500,-. Dan terlihat nota PB-210126008 ko ahok ada di halaman BAYAR.

Contoh Ketiga:
Ncek Jet Lee bilang ke pak Adi : “Pak Adi, ngai bayal semua nota yang bulan Januali 2020 ya. Totalnya 8.187.670 lupiah.” Maka dalam hal ini, yang digunakan adalah tombol Semua Nota, dimana dipilih item “January 2020” pada box BlnThn. Seperti pada gambar-9 dibawah ini.

gambar-9

Total utang ncek Jet Lee nanti menjadi Rp 26.525.320 – Rp 8.187.670 = Rp 18.337.650,-. Dan terlihat semua nota Januari 2020 ncek Jet Lee ada di halaman BAYAR.

Contoh Ke-empat:
Bolot bilang ke pak Adi : “Di, gue bayar Rp 1.485.000 untuk dua nota dulu ya. Satu nota yang bulan Desember 2020, satu lagi nota yang bulan Januari 2021. Dua duanya yang nilainya dibawah satu juta itu loch.” Disini kembali digunakan tombol Nota Dipilih. Namun karena nomor nota-nya yang dibayar itu loncat, maka perlu tekan Ctrl pada keyboard sambil memilih satu persatu kedua nota yang nomor-nya loncat tsb dengan mouse. Seperti yang terlihat pada gambar-10 dibawah ini.

gambar-10

Total hutang Bolot nanti akan menjadi Rp 4.769.100 – Rp 1.485.000 = Rp 3.284.100. Terlihat pula dua nota yang Bolot bayarkan berada di dua baris terakhir pada halaman BAYAR.

Contoh Kelima:
Mak Lampir bilang ke pak Adi : “iiii hihihihiiii…. hai Adi, utang Maret 2020 ku kan ada 7 nota. Aku bayar sampai yang tanggal 18 Maret dulu ya. Jadi sisa utang Maret-ku tinggal dua nota, tanggal 21 dan 28 Maret. Iiiii hihihihihiiii….” Kembali lagi disini digunakan tombol Nota Dipilih. Dan karena nomor nota-nya ber-urut, pak Adi tinggal memilih lima nota pertama bulan Maret si emak dengan cara menyeret. Seperti yang terlihat di gambar-11 dibawah ini.

gambar-11

Total utang mak Lampir nanti menjadi Rp 7.989.060 – Rp 1.517.200 = Rp 6.471.860. Terlihat lima buah invoice Maret mak Lampir di lima baris terakhir halaman BAYAR.

Sampai disini pak Adi cukup puas atas hasil membuat macro userform Excel-nya, karena macro bekerja sesuai yang dia harapkan. Hal selanjutnya adalah meng-input nota nota yang berada di halaman BAYAR tsb ke data utama. Ada baik-nya halaman berikutnya dibuka pada tab browser baru, agar mudah untuk mengecek/membandingkan hasil kerja kode macro-nya sama atau kagak dengan perhitungan manual nilai nilai sisa hutang para customer yang membayar diatas tadi.

Kini saatnya pak Adi meng-input nota nota yang terdapat di halaman BAYAR tsb ke halaman DATA.

744 replies on “Macro untuk Excel UserForm input pembayaran”

สล็อตออนไลน์เกมคาสิโนยอดนิยมนิรันดร เล่นง่าย แจ็คพอตแตกไวจำเป็นที่จะต้องที่ UFABET จ่ายจริง จ่ายเต็ม มีเกมให้เลือกเยอะแยะทั้งพนันบอล บาคาร่า ยิงปลา มาเว็บไซต์แห่งนี้เว็บเดียวโคตรคุ้ม สร้างรายได้ง่ายจบที่เว็บไซต์ UFABET ได้เลยครับผม

Aw, this was an extremely nice post. Spending some time and actual effort to produce a really good articleÖ but what can I sayÖ I procrastinate a lot and never manage to get nearly anything done.

Pretty section of content. I just stumbled upon your blog and in accession capital to assert that I get actually enjoyed account your blog posts.Any way I will be subscribing to your feeds and even I achievement you access consistently fast.

Hey There. I found your blog using msn. This is a very well written article. I will be sure to bookmark it and come back to read more of your useful information. Thanks for the post. I will definitely return.

Wonderful to fulfill you, my title is Jere. Managing people has been his job for some time and his salary has been really satisfying. His property is now in Indiana. Jogging is the thing I enjoy most.

You could definitely see your skills within the paintings you write.The world hopes for even more passionate writers such as you who aren’t afraid to say how they believe.Always go after your heart.Look into my blog … moonlightmining.com

Thanks for your personal marvelous posting!I quite enjoyed reading it, you might be a great author.I will always bookmark your blog and may come back from nowon. I want to encourage continue your great writing, have a nice afternoon!

Aw, this was an extremely good post. Spending some time and actual effort to produce a really good article… but what can I say… I hesitate a whole lot and don’t seem to get anything done.

It’s really a nice and helpful piece of info. I’m satisfied thatyou just shared this useful information with us. Please stayus up to date like this. Thank you for sharing. 0mniartist asmr

Very nice post and right to the point. I am not sure if this is truly the best place to ask but do you folks have any thoughts on where to get some professional writers? Thx

Hello! This is my first visit to your blog!We are a team of volunteers and starting a new project in acommunity in the same niche. Your blog provided us valuableinformation to work on. You have done a wonderful job!

A fascinating discussion is definitely worth comment.I believe that you ought to publish more about this topic, it may not be a taboo subject but typically people do not talk about such topics.To the next! Cheers!!

จริงๆเล่นมาหลายเว็บไซต์เลยจ๊ะขอรับ ส่วนใหญ่ก็จ่ายจริงนะครับ แต่ที่ต่างเป็นบางเว็บไซต์เวลาฝาก-ถอนควรต้องผ่านผู้แทนนะครับ ควรต้องแคปจอส่งให้บุคลากร ผมว่าป่วยเลย มี UFABET นี่แหละครับ ผมว่าระบบดีสุดเลย ฝากถอนอัตโนมัติทำเองได้เลยขอรับ

When I initially 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? Thanks a lot!

I don’t even know how I ended up here, but I thought thispost was good. I don’t know who you are but definitely you are going to a famous blogger if you are not already 😉 Cheers!

Hey there! This is my first visit to your blog! We are a collection of volunteersand starting a new initiative in a community in the same niche.Your blog provided us beneficial information to work on. You havedone a wonderful job!

Hey! This post could not be written any better! Reading through this post reminds me of my previous room mate! He always kept chatting about this. I will forward this post to him. Fairly certain he will have a good read. Thanks for sharing!

I’m not sure where you’re getting your info, but greattopic. I needs to spend some time learning more or understanding more.Thanks for great information I was looking for this info for my mission.

Thank you, I have just been looking for info about this subject for a while and yoursis the best I have came upon till now. However, what concerning the conclusion? Are you sure in regards to the source?My blog post – clubriders.men

Hi my family member! I wish to say that this post is amazing,great written and include almost all significant infos.I would like to peer extra posts like this.my blog :: Keto 3DS Reviews

Very interesting points you have observed , thankyou for putting up. „Brass bands are all very well in their place – outdoors and several miles away.” by Sir Thomas Beecham.

I am extremely impressed with your writing skills as well as with the layout on your blog. Is this a paid theme or did you modify it yourself? Either way keep up the excellent quality writing, it’s rare to see a nice blog like this one these days.

What’s Taking place i’m new to this, I stumbledupon this I have discovered It positively helpfuland it has helped me out loads. I hope to contribute& aid other users like its aided me. Great job.

Having read this I thought it was rather informative. I appreciate you finding the time and energy to put poker this informative article together. I once again find myself spending way too much time both reading and leaving comments

Oh my goodness! Incredible article dude!Thanks, However I am having problems with your RSS.I don’t understand why I can’t subscribe to it.Is there anybody getting the same RSS issues? Anybody whoknows the answer can you kindly respond? Thanx!!

hi!,I like your writing very much! share we communicate more about your post on AOL? I require an expert on this area to solve my problem. Maybe that’s you! Looking forward to see you.

Oh my goodness! Incredible article dude! Thanks, However I am experiencing troubles with your RSS. I don’t know why I cannot join it. Is there anybody getting the same RSS issues? Anyone that knows the solution can you kindly respond? Thanks!

Hey there! I’m at work surfing around your blog from my new iphone 3gs! Just wanted to say I love reading your blog and look forward to all your posts! Keep up the great work!

Normally I do not learn post on blogs, however I would like to say that this write-up very forced me to take a look at anddo it! Your writing taste has been surprised me. Thanks, very nicearticle.

Howdy! Do you know if they make any plugins to assist with SEO?I’m trying to get my blog to rank for some targeted keywords but I’m not seeing very good results.If you know of any please share. Thanks!

Do you have a spam issue on this blog; I also am a blogger, and Iwas wanting to know your situation; we have developed some nice methods and we are lookingto trade strategies with others, please shoot me an e-mail ifinterested.

Good day! Do you know if they make any plugins to assist with Search Engine Optimization? I’m trying to get my blog to rank for some targeted keywordsbut I’m not seeing very good gains. If you know of any please share.Kudos!

Hi there, just became aware of your blog through Google, and found that it’s really informative.I’m going to watch out for brussels. I’ll appreciate if you continuethis in future. Numerous people will be benefited from yourwriting. Cheers!

Good blog! I really love how it is simple on my eyes and the data are well written. I am wondering how I might be notified whenever a new post has been made. I’ve subscribed to your feed which must do the trick! Have a nice day!

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 three emails with the same comment. Is there any way you can remove people from that service? Thanks a lot!

Great post. I was checking constantly this blog and I’m impressed!Extremely helpful info specifically the last part 🙂 I care for suchinfo much. I was looking for this certain information for a very longtime. Thank you and good luck.

Oh my goodness! an amazing article dude. Thank you However I am experiencing issue with ur rss . Don’t know why Unable to subscribe to it. Is there anyone getting identical rss problem? Anyone who knows kindly respond. Thanks

Hey, you used to write wonderful, but the last few posts have been kinda boring¡K I miss your tremendous writings. Past several posts are just a little bit out of track! come on!

Very nice post. I just stumbled upon your blog and wanted to say that I have really enjoyed surfing around your blog posts. After all I?ll be subscribing to your rss feed and I hope you write again soon!

wonderful post, very informative. I ponder why the other experts of this sector don’t understand this.You should continue your writing. I’m sure, you havea huge readers’ base already!

Thanks for one’s marvelous posting! I quite enjoyed reading it,you are a great author. I will make sure to bookmark your blog and definitely will come back from now on. Iwant to encourage yourself to continue your great work, have a nice morning!

La suscripción se basa en el sistema de puntos, básicamente estás comprando puntos para usarlos cuando te suscribes. AKA puedes parar en cualquier momento (¡sólo coge un montón de puntos y vete si quieres!). 

I blog often and I genuinely thank you for your information. This article has truly peaked my interest. I’m going to book mark your blog and keep checking for new details about once per week. I subscribed to your Feed too.

I have to be able to voice my passion regarding your kindness giving help to those people of which needs to have guidance on this kind of important matter.

When I originally commented I clicked the “Notify me when new comments are added” checkbox and now eachtime a comment is added I get four emails with the same comment.Is there any way you can remove people from that service?Appreciate it!

Howdy! I know this is kinda off topic but I was wondering ifyou knew where I could locate a captcha plugin for mycomment form? I’m using the same blog platform as yours and I’m having problemsfinding one? Thanks a lot!

hello!,I love your writing so so much! sharewe keep up a correspondence more approximately your article on AOL?I need an expert on this area to solve my problem. May be that is you!Taking a look forward to see you.

I was ѕuggested thiѕ ԝebsіte by means of my cousin. I’m now not sure whetherthis submit is written by way of him as nobody eⅼse knowsuch detailed approximately my tr᧐uble. Y᧐u are amazing!Thankѕ!My blog post :: daftar gboslot

Thanks , I’ve not too long ago been seeking information regarding this topic for many years and yours is the greatest I’ve found out to date. But, How about the summary? Have you been guaranteed concerning the resource?

I ddo consider all of thee concepts you have presented toyour post. They’re really convincing and will certainly work.Still, the posts are too quick for newbies. Could you please lengthen them a liuttlefrom next time? Thanks for the post.

Pretty section of content. I just stumbled upon your blog and in accession capital to assert that I acquire actually enjoyed account your blog posts. Anyway I’ll be subscribing to your augment and even I achievement you access consistently fast.

Hi, I do believe this is an excellent blog. I stumbledupon it 😉 I will return once again since i have bookmarked it. Money and freedom is the greatest way to change, may you be rich and continue to guide others.

I’m in a band wellbutrin annual sales Mr Cable believes the BoE has held back small business lending by demanding banks hold onerous levels of capital as a cushion against further shocks, a view shared by George Osborne, chancellor.

I don’t even know how I ended up here, butI thought this post was good. I do not know whoyou are but definitely you are going to a famous blogger if you aren’t already 😉 Cheers!

Good day! Do you know if they make any plugins to assistwith Search Engine Optimization? I’m trying to get my blog to rank for some targeted keywords but I’m not seeing very good gains.If you know of any please share. Thank you!

Aw, this was an extremely good post. Finding the time and actual effort to create a top notch articleÖ but what can I sayÖ I put things off a lot and don’t manage to get nearly anything done.

A motivating discussion is worth comment. I do think that you should publish more on this topic, it may not be a taboo subject but usually folks don’t speak about such subjects. To the next! Many thanks!!

What’s Going down i am new to this, I stumbled upon this I have found It positively useful and it has helped me out loads. I hope to contribute & aid different users like its helped me. Good job.

Hi there, just became alert to your blog through Google, and found that it is truly informative. I am gonna watch out for brussels. I will appreciate if you continue this in future. Numerous people will be benefited from your writing. Cheers!

It’s truly very complicated in this activelife to listen news on TV, therefore I simply use internet for that reason, andobtain the hottest news.

F*ckin’ remarkable issues here. I’m very satisfied to look your article. Thanks a lot and i am having a look forward to touch you. Will you please drop me a mail?

Excellent post. I was checking constantly this blog and I am impressed! Extremely helpful information specially the last part 🙂 I care for such information much. I was looking for this particular info for a very long time. Thank you and good luck.

คลิปหลุด เว็บโป๊ใหม่ คลิปหลุดนักศึกษา สาวน่ารัก คลิปโป๊ javhubpremium ไลฟ์สด mliveหนังโป๊มาใหม่ทุกวันjav

Greetings! I know this is kind of off topic but I was wondering if you knew whereI could locate a captcha plugin for my comment form? I’m using thesame blog platform as yours and I’m having trouble finding one?Thanks a lot!

Usually I do not learn post on blogs, but I wish to say that this write-up very pressured me to try and do it! Your writing taste has been amazed me. Thank you, very great article.

Thank you for your sharing. I am worried that I lack creative ideas. It is your article that makes me full of hope. Thank you. But, I have a question, can you help me?

Hey There. I found your blog using msn. This is a very well
written article. I’ll make sure to bookmark it and come back to read more of your useful information. Thanks for the post.
I will definitely comeback.

Have you ever thought about creating an e-book
or guest authoring on other sites? I have a blog based upon on the same information you discuss and would love
to have you share some stories/information. I know my readers
would value your work. If you are even remotely interested, feel free to shoot me an email.

Pretty nice post. I just stumbled upon your weblog
and wished to say that I have truly enjoyed browsing your
blog posts. After all I’ll be subscribing to your feed and I
hope you write again soon!

Heya i’m for the first time here. I came across this board and I find
It really useful & it helped me out a lot. I hope to give something back and aid others like you helped me.

Thanks for another informative blog. The place else
could I am getting that kind of information written in such a perfect manner?
I’ve a undertaking that I’m simply now running on,
and I’ve been at the look out for such info.

Leave a Reply

Your email address will not be published. Required fields are marked *