Application for SIZ IT-Tech Course | 04 Week course On Visual Basic Application (VBA) | 20% Reward To @siz-official
Assalam-O-Alaikum!
Hope you all are doing well.
Today I will tell you about the VBA. Welcome to my first post in SIZ. I would like to thank this @siz-official community.
Here I'm wanted to share my skill and teach about VBA to beautiful members of this great learning community. When my Course would be approved by community policies, I will share the first lecture.
After learning this course you must be able to create automated Inventory Management Software, Employee Attendance, Super Store Billing Software, and many more.
This course contains 4 lectures and I'm sharing the 1st Lecture.....
Lecture#1
- Introduction
- Macro Recording
- Variables and Data type
- Comments
Lecture#2
- Input Box and Message Box
- IF THEN ELSE
- Select Case
- Workbooks
Lecture#3
- Worksheets
- Cells and Range
- Formatting
- Cut, Copy and Paste
- Sort and Filter
Lecture#4
- Loops in VBA
- VBA and Worksheet Functions
- User-Defined Functions
- Error Handling
- ADODB Connection
Sample of Inventory Management
This is made for a superstore for stock management.
Here we will learn VBA with MS Excel. We can automate our daily work, which we do in excel.
Approved.
You can start posting
Thanks very much Maim @vvarishayy for approval and giving me a chance to show my abilities.