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...
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...
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...
Input Box and “Smart” Input Box
The most easiest and commonly used function in VBA is Input Box. Without much VBA coding, user can be asked to enter some input at any point of programming. To illustrate the simplicity of Input Box we will take an example. Example: You are trying to add a New...
Merry Xmas to you All – 2012
Dear Friends, Wishing you a very very happy Christmas to you all. May God bless you all with tons of happiness and love. Enjoy !! Merry Christmas
Get Special Folder Path using VBA
Hello Friends, In this article I am going to explain you how to get the path of Special Folders in Windows Operating System. Using VBA we can get path of Special folders path like, Desktop, My Documents, Library etc. Few important special folders are listed below....
Sending a HTML Email using Word Email Template and Excel Macros
How to Send a HTML Email using Word Email Template using Excel Macro Hi All, This is my very first post for learnexcelmacro.com. Thanks to Vishwa for roping me in for this good cause. Your Help/ comments / suggestions for improving this better. Things Needed:...
Download : Excel Macro Application to Send Multiple Emails – 2.0
Hello Friends, I got many good response on the tool - Send Multiple Email Workbook. I also got a request to implement much other functionality as well. The attachment was one of them. In this version, I have added the attachment functionality with some other small...
Send Sheet as a PDF attachment in Email
Dear Readers, In my previous article, you saw how to save an Excel Sheet as PDF file. Now you know, how to save an Excel Sheet as a pdf. Also, we have seen how to send the ActiveSheet as an attachment in Email. In this article, I am going to show you how to send the...
How to Export an Excel Sheet as PDF file
Dear Readers, In this article you are going to learn How to save an Excel Sheet as pdf file. Many a times we generate certain reports in an Excel Sheet but while sending that report to your boss, you want that to be saved in a PDF form. In such case you can simply...
Buy a coffee for the author
What is Excel Formula?
Excel Formula is one of the best feature in Microsoft Excel, which makes Excel a very very rich application. There are so many useful built-in formulas available in Excel, which makes our work easier in Excel. For all the automated work, Excel Macro is not required. There are so many automated things can be done by using simple formulas in Excel. Formulas are simple text (With a Syntax) which is entered in to the Excel Worksheet Cells. So how computer will recognize whether it is a formula or simple text? Answer is simple.. every formula in Excel starts with Equal Sign (=).
Excel Macro Tutorial : Excel Form
In this article, I am going to explain every aspect of the VBA Form. User forms in Excel are really nice to see. It...
How to Send an Email using Excel Macro from Gmail or Yahoo
Dear Readers, In this article, we are going to learn how to send an email automatically by Excel Excel VBA. While...
Textbox first Letter in Caps and Rest other in Lowercase
If you want to automatically make first letter in Uppercase and rest of the characters in lowercase. No matter what...
Recommended articles
Recommended Articles
![40 Useful Excel Macro [VBA] examples – Part 1 of 2](https://vmlogger.com/excel/wp-content/uploads/sites/11/2018/06/40-useful-excel-vb-code-2-1.png)
40 Useful Excel Macro [VBA] examples – Part 1 of 2
Dear Friends, Here in this article, I have tried to consolidate some most useful and more frequently used excel macro...
Random BSN Generator – SoFiNummer Generator
Dear Friends, In one of my previous article, I explained you about Netherlands BSN Number validation. This used to be...
VBA to Convert Contact Data in Excel to VCF format
Dear Friends, As you have learned about interacting with Text files through Excel VBA, it is time to see the usage of...
Validate BurgerServiceNummer (BSN) using Excel VBA
Important Note: This post will make more sense to those who stay in the Netherlands. Also do not forget to download...