Monthly Archives: June 2013

How to insert a picture in excel using VBA

Dear Friends,   This is not a big article. It is based on request from one of LEM reader who wants to know, How to insert a selected picture in excel using VBA code It is a very simple one liner code to insert a picture in Excel using vba code.   Syntax: ActiveSheet.Pictures.Insert('full path of the picture [...]

Few very useful and small macros

Dear LEM Readers,   In this first part of this article I am going to share very small but useful vba codes which are most frequently used in day-to-day vba programming. Many of my readers had requested for them so I have clubbed all of them together and made one article :) Enjoy reading them...   Closing All Open Workbooks [...]

Check if file is already open using excel VBA

Dear LEM Readers,   While doing programming with VBA many a times it happens to open an existing file. Before opening that file, it is always a good idea to check if that file is already open or not. Therefore I have written a function (IsFileOpen()) which takes the complete path of that file (with file name) as an Input [...]

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 button which can be triggered by pressing that hot key from the keyboard. It means you can perform the operation either by clicking on the command button or by pressing the hot key.   [...]

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 option. In this article you will learn how to assign shortcut keys to your already written procedure or subroutine using VBA (excel macro). At the end of this article you will be comfortable enough with association shortcut keys for your [...]

How to assign a Shortcut key to a Procedure or Subroutine

Dear LEM (Learn Exel Macro) Readers, It's been long time I wrote any article or answered any of your queries. Apologies for the delay in response. I am back with many more amazing articles now. All your un-answered questions will be answered in few days with a set of few interesting articles which will make you awesome in excel VBA [...]