Beginner tutorial for Word macro/VBA (automatic price calculation of an invoice)

preview_player
Показать описание
In this video you will learn how to create a fully automated invoice in Word by creating your own custom macro. It will require a bit of VBA coding, but I created the video beginner-friendly, so you'll understand it even if you are completely new to macros and VBA.

Note, that it is always best, that you follow the instructions and learn how to create the template and code yourself. Like that, you can then easily change some settings and the styling. And you will never again need an invoice generator.

00:00 What you will learn
00:24 Create macro
01:00 Planning code structure
02:05 Declaring constants
02:50 Declaring variables
03:30 Get values from document
05:01 For loop
09:29 InputBox for tax rate
09:45 Tax, subtotal and total
11:05 How to run the macro

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
💗 I need your support. Yes, YOU can help me (if you want it).

If I helped you, I would really appreciate it if you subscribe to my channel, leave a comment 📝 and hit the like button 👍
Рекомендации по теме
Комментарии
Автор

If this video was helpful for you, please like the video ☺ Thank you ❤

LeonRenner
Автор

Hi how can I add an hour field where a person can choose a time in the format HH:MM?

fraanarena
Автор

Hello sir, If we share topics of the stream: (Commerce; Engineering CS & IT) branch will You be able to create detailed videos on those topics to understand them very easily?

MOHITAGARWAL-flnh