I'm glad to start writing about the most powerful and world's most popular Microsoft Excel Visual Basic for Application. Well in short, Visual Basic is a programming language of Microsoft. It is very user friendly application development programming language. As like as previous others version, Microsoft Office version included Visual Basic. In general, VB (short term of Visual Basic) is using for application development here with Microsoft Excel and some others package software of Microsoft Office 2016 like Microsoft Access, Microsoft Word etc. Microsoft Excel VBA (Visual basic for Application) has a lot of thing which make the Microsoft Excel more powerful to calculate or generate reports in seconds.
You know EXCEL VBA can do many interesting task in just a seconds. You can design your own input form, various dashboard, chart etc. I think EXCEL VBA is a powerful tool to do EXCEL task more faster.
For example, You need to design a table with border every day in a specific worksheet. These would take more than 20 to 60 seconds. If you create a macro (a short cut command of a large task) with VBA in the same file and use it like a short cut command from your Keyboard or by a mouse click on a button, then your table design will done in just 1 or 2 seconds.
Many people think that, creating a macro or writing codes is very hard in VBA, then I would say, it would be very easy if they start from 0 (Zero). I am writing here with 0 (Zero) VBA knowledge. I believe I can do it to help you to know the Excel VBA properly.
Image 1: Excel VBA
You know EXCEL VBA can do many interesting task in just a seconds. You can design your own input form, various dashboard, chart etc. I think EXCEL VBA is a powerful tool to do EXCEL task more faster.
For example, You need to design a table with border every day in a specific worksheet. These would take more than 20 to 60 seconds. If you create a macro (a short cut command of a large task) with VBA in the same file and use it like a short cut command from your Keyboard or by a mouse click on a button, then your table design will done in just 1 or 2 seconds.
Many people think that, creating a macro or writing codes is very hard in VBA, then I would say, it would be very easy if they start from 0 (Zero). I am writing here with 0 (Zero) VBA knowledge. I believe I can do it to help you to know the Excel VBA properly.