Are you looking for a macro to select the date? Recently I was looking for some type of calendar or built-in dialog box that would enable a user to select the date which I would then feed into my macro. I saw one option but that looked too involved for my purposes so I wrote my own function. Continue reading
Tag Archives: VBA functions
Introduction to VBA Functions
Today I introduce VBA functions using the emailing from Excel macro as my example. We will look at how functions are different to a sub, how to declare a function and how to use arguments, especially optional arguments. I conclude by outlining the steps in the emailing from Excel macro. Continue reading
Email from Excel Macro
Reply
You can email from Excel with a macro using an email address in your VBA code or in your Excel file. There are several different ways of doing this. This post looks at the one using a Windows Application Programming Interface (API) function called ShellExecute. Continue reading