Excel Macro Beginner

This category holds articles which are for the beginner to Excel Macro. If you are new to Excel Macro then this is the right place for you.

3 Methods to Comment or Uncomment in Excel VBA

Dear Friends, This is a very simple yet useful article, especially for beginners. Sometimes even intermediate level users also does not know about all these options to comment a line or group of lines in Excel VBA. Like every other programming languages, VBA too has an option to comment a line or group of lines in your code. For those [...]

Schedule to close Workbook using Application.OnTime

Dear Friends, In this article I am going to teach you about Application.OnTime. I will also explain you the usage of this method with two examples: How to schedule a workbook to close at specified time How to Schedule a workbook to close if left idle for specified duration This method is used to execute a procedure in Excel VBA [...]

What is Immediate Window and how to use it in Excel VBA

Dear Friends, Have you heard of Immediate Window in Excel VBA programming? Do you know how to make use of it? If you have not been using this while doing vba programming then trust me you were missing something really cool stuff which excel provided to the programmers. In this article I am going to explain you the following 1. [...]

Windows FileDialog to Select File or Folder Path in VBA

Dear friends, In my many of the Excel Tools, wherever there is a need of file path to be entered from your local PC, I try to put a browse button to locate that file in your Windows PC through windows file explorer window. It is the same window which you might have seen in windows for selecting a file. [...]

How to create folders in windows via Excel VBA

Dear LEM Readers, Till now, I had published many articles on how to list files from a folder / sub folder,

[VIDEO] Excel VBA Tip – Hide Horizontal scroll bar in Excel

Dear Readers, Every week, I am going to publish at least one Excel VBA Tip where I will be sharing some small code snippets, tips, tricks which will be useful for you during development of any Excel VBA tool. YouTube Channel You can subscribe to LearnExcelMacro.com Channel where all the videos are going to be uploaded. You will be notified [...]

[VIDEO] Excel Macro Tutorial-Part-2- Your first VBA Program

Dear Readers, Here is the second episode of the Excel Macro Tutorial for Beginners. If you have not watched the first part of the Tutorial, you can watch it here or on the YouTube Channel. Kindly provide your feedback on this video. Any improvements/ suggestions are always welcome. You can provide your feedback by typing comments in this article or [...]

[VIDEO] Excel Macro Tutorial-Part-1-Introduction to Excel VBA

Dear Readers, Recently, I realized that Videos/audios are sometimes more easy medium for a blogger like me who is mainly teaching some new things in Microsoft Excel area, to convey the message in a very appropriate way. At the same time, for a reader as well it is very easy to learn things by watching the video rather reading some [...]

Button to Zoom in a Graph in Excel – [Method 2]

Hello Friends, How are you doing? I am back with my next article about "how to make a button to zoom-in and zoom-out a graph in Excel VBA". this is the second method I am going to explain you. In my previous article, I had explained about the very basic method. There were 4 limitations in the previous method which [...]

Button to Zoom in a Graph in Excel – [Method 1]

I wish Microsoft Excel has a built-in feature to Zoom-in and Zoom out a graph made in Excel :) like many other web applications. But not to worry, you can easily create one to simulate the Zoom-in and Zoom out feature on an Excel graph. There are more than one workaround to achieve this. Though each workarounds are having few [...]

Page 1 of 3123