You can use the Change event of the ComboBox to capture the selected value and run a procedure ...
Let us assume, I have multiple tables in my Excel worksheet. I want to email the tables as it is (with color, fonts etc.) as HTML table in the email body. I’ll show you how easily you can do this ...
You can use VLOOKUP in Excel to search a particular value in a dataset like a named range. Even though its a worksheet function, you can use VLOOKUP in VBA for more dynamic use. ...
In this tutorial, I’ll show you how to create and add ActiveX Controls dynamically in a UserForm and save all the data (extracted from the controls) in an SQL Server table. ...
Well, you can send emails from Excel using Outlook and a simple Macro. No worries if you dont have access to Outlook or for some reason dont want to use Outlook from Excel. You can still send ...
Here in this post, I will show you how to create a simple progress bar in Excel using UserForm and VBA ...
In this tutorial I will show you how to import or extract Outlook emails into a Word document using VBA. Importing emails from Outlook into Word (or Excel) can help you analyze the data ...
Heres a list of important Excel keyboard shortcuts that you should know to improve your productivity. ...
In VBA, you can use the BorderColor property to change the border color of a textbox on certain condition ...
You can easily add a drop-down list in Excel. How to run a macro when a value from drop-down is selected? ...