Monthly Archives: October 2011

Different Settings of Controls in Excel Macro

When we re-size the cell size in Excel, my controls like buttons, text boxes etc. also get moved and re-sized. In this post we will see how can change the setting to get rid of this issue. 1. Go to Developer Tab of the Excel Sheet where your control exists. […]

By |Categories: Excel Macro Basics|0 Comments

Excel Macro Tutorial : How to add different types of controls like Text Box, Radio button, button etc. in Excel

Dear Readers, This is the 3rd Article of this Excel Macro Tutorial. In this Article, we are going to see How to add different types of controls like Text Box, Radio button, button etc. in to the Excel   Follow the below Steps one-by-one to Add Controls in your Excel Workbook or else watch my Video tutorial here:   1. [...]

Excel Macro Tutorial : What is Excel Macro ?

Dear Beginner, In this Excel Macros Tutorial, you are going to learn the Basics of Excel Macro. This is the first Article of this Tutorial so Let's begin with What is Excel Macro What is Excel Macro ? Macro is really great tool. It allows you to perform multiple operations just by clicking a simple button or changing a cell [...]

Excel Macro Tutorial : Add Developer Tab in Excel – 2007 and 2010

In the Previous Article What is Excel Macro of Excel Macro Tutorial, you have read, what is Macro, How to Record Macro and How to Run Macro. Before starting writing Macro in Excel 2007/2010, we need Developer Tab, where all the controls, options, settings are there for Excel VBA. You can add developer Tab in your excel 2007 or 2010 [...]

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 want to add a new sheet always with certain format. In this case, either we first add a new Sheet to the workbook without any formatting and then do the same formatting using macro, or make a Template (Sheet) which has exactly the same format what you want in each sheet and […]

How to restrict some key or Characters in text box in a Excel Macro

When you are using Text Boxes in Excel Macros then there are some instances where you want to restrict some entries in the Text Box. For example: A Textbox where you are entering Amount. Here you may need that you should be able to Enter All numeric characters from 0-9 and also Decimal (.) and Minus Sign(-). You don’t have any inbuilt functionality in Excel Textbox to restrict it to only Numeric Value. However by writing a piece of Code under KeyPress Event of Textbox, you can achieve this. Just copy paste the below mentioned code under KeyPress Event of the Text Box. […]

How to display different types of message box in excel macro

How to display different types of message box in excel macro. Change the STYLE in the below code from the below given table and use message boxes as per your requirement like […]

By |Categories: Excel Macro|0 Comments

How to save and Close an Excel Sheet using Macro

Here I am going to give an idea how we can save and close the current excel sheet using Macro. This function can be written in the Module and can be called any where in the program where we want to save the Excel and Close it. The below code will save and close only the Workbook where […]

By |Categories: Excel Macro|0 Comments

How to delete a selected sheet using Excel Macro

Today we will learn how to delete a selected Sheet from a Workbook. First we need to traverse all the sheets of the workbook to check whether the sheet with the given name exists in the workbook. If not, then we should throw an error otherwise go ahead and […]

By |Categories: Excel Macro|0 Comments

Update cell value after change is made in different cell or Cell Range

If we want to update a column with the current date as and when any cell range is getting changed. This is used when we want to track the date modified of a cell range. Copy and Paste the following piece of code and […]

By |Categories: Excel Macro|0 Comments
Page 1 of 212