You can dynamically change column width or the row height in your Excel worksheet using simple properties in VBA. It becomes necessary when you have texts or data in columns that either hides or over ...
The Replace function in Excel is an inbuilt function or a pre-defined function, which you can use in your Macro to replace a set of characters in a string with another set of characters. You can ...
A File dialog box allows you to choose one or more files from a folder in your computer. You can open a file dialog box from your Excel worksheet using VBA. Microsoft Excel’s “.FileDialog” method of ...
A chart shows data in a graphical format. A Pie chart is a circular chart where it divides the data into slices. Each slice represents a part of the data. Here in this post I’ll show you how to create ...
You can insert different kinds of shapes in your Excel worksheet, like a circle or a rectangle etc. These shapes can be used for various purposes and you can easily change its properties like ...
You know there are two ways to create Pie charts in Excel. One, create a Pie chart on your own using the tools available or you can use VBA to create Pie charts automatically with the click of a ...
I have previously shared an article with an example showing how to open a word document from excel and copy excel data, a table, to the word doc using VBA. You can reverse the process, that is ...
It is very easy to add text to shapes dynamically in Excel using VBA, provided you know the properties. VBA’s “Shape” object provides a property called “TextFrame”, which gives access to the text of ...
You can open a new word file or document from Excel using VBA. Here in this post I’ll show you an example on how to open a word file from Excel using a Macro. I’ll also show you how to copy Excel data ...
You must have read my previous article on how to send emails from Excel using VBA macro and Outlook. Now, here in this post I am sharing an example on how to Parse or Extract Outlook emails and show ...