About Vishwamitra Mishra

My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor’s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.
Thanks for visiting my blog.

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. […]

Excel VBA Tutorial – Different types of message box in excel macro

Dear 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 accordingly. With Type of Message, I mean, is it a warning? Is it an Info? Is it [...]

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 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 are many scenarios - based on how and which sheet [...]

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

How to disable/Invisible Horizontal/Vertical Scroll Bar

While developing some Excel VBA based tool 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 Horizontal or Vertical Scroll bar using VBA code. They are self explanatory by the way. So here you go: To enable/visible Horizontal and Vertical Scroll Bar To disable/invisible Horizontal and Vertical Scroll Bar […]