In last post Excel Macro Tutorial : Visual Basic Editor in Excel we saw how to add different Controls in your Excel Macro. To Read All the Excel Macro Tutorial Click Here. Each and Every VBA controls has their own by default properties. Like Name of the...
Results for "while"
Delete Sheet In VBA Without Notification
Dear Friends, While automating in Excel through Excel VBA, you may want to delete or add some Worksheets. This is a very common task, which we try to do. I have already written an article where I have explained a lot about deleting worksheets using Excel VBA. In this...
Wait Function
Even more wait for Gane of thrones New Season??? Noooo !!! Who in real life would like to wait... especially for Game Of Thrones 😀 No one would like to wait for any thing in real life 🙂 Sometimes, while doing Automation in Excel Macro we require a "Wait" or "Sleep"...
Add a Sheet using Excel Macros
Adding a sheet in Already existing workbook is very easy. It can be done manually easily. Here we are going to learn, how to add a Sheet in an already existing workbook using Excel Macro. For doing so, there can be many possibilities. For example: we might...
Excel VBA Tutorial – Different types of message box in excel macro
[fusion_text]ear friends, You must have seen windows message boxes. As the names suggests, they are basically used as a popup to give some message to the user on screen. Based on type of message you are sending, you can format your message box...
Excel VBA Tutorial – Save and Close Excel workbook
Step by Step Guide to Save and Close Workbooks Index: Save and close all open workbooks including current one Save and close all open workbooks without closing the current one Save and close a specific workbook Save and close a current workbook Only Close a workbook...
How to delete sheet using Excel Macro
Dear Friends, While automating in Excel through Excel VBA, you may want to delete or add some Worksheets. This is a very common task, which we try to do. In this article, I am going to teach you all about deleting the Sheets from a workbook through Excel VBA. There...
How to disable/Invisible Horizontal/Vertical Scroll Bar
While developing some Excel VBA based tools in Excel, you might find this useful when you want to disable or enable horizontal or vertical scrolling in excel automatically. It is very easy to disable the Horizontal or Vertical Scroll bar using the VBA code. They are...
Buy a coffee for the author
Download FREE Tools and Templates
There are many cool and useful excel tools and templates available to download for free. For most of the tools, you get the entire VBA code base too which you can look into it, play around it, and customize according to your need.
What is Excel Formula?
Excel Formula is one of the best feature in Microsoft Excel, which makes Excel a very very rich application. There are so many useful built-in formulas available in Excel, which makes our work easier in Excel. For all the automated work, Excel Macro is not required. There are so many automated things can be done by using simple formulas in Excel. Formulas are simple text (With a Syntax) which is entered in to the Excel Worksheet Cells. So how computer will recognize whether it is a formula or simple text? Answer is simple.. every formula in Excel starts with Equal Sign (=).
5 very useful and small macros
In the first part of this article, I am going to share very small but useful VBA codes which are most frequently used...
Assign a Hot Key to a Command Button in Excel
In Excel VBA you can assign a hot key for a command Button as well. It means you can assign a hot key to a command...
Assign a Shortcut Key using Excel VBA
Dear LEM Readers, In the previous article, you learnt how to assign or modify a shortcut key using excel...