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.

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

How to Get Excel version using VBA Code

Dear Friends, Usually while working on any of the VBA projects, it becomes important for me to first check the version of excel which user is using and based on that certain functionality of my tool may or may not work. For Example: If you have some sales data using more than 256 columns then if user is using Excel [...]

Invoice Template [ FREE Download ]

Hello friends, There are many small businesses which are using Excel for their day-to-day management. Like Generating invoice, quotation, tracking data about customers, sales, employees etc. In nutshell complete management is done in excel spreadsheets. I manage my articles, tools repository and excel assignments in excel spreadsheets too. I thought of sharing with you all the invoice template which I [...]

VBA Beginners: How to write macro for a Command Button

Dear Beginners, Quite a few times I was getting this question from my readers - How to associate a VBA code to a button? How to write a vba code which gets executed by clicking on a command button in excel vba. Add a button to trigger my macro and so on... Here are 3 simple steps by which you [...]

Page 1 of 3123