Excel

Excel Automation

Create Custom Commands for Excel - VBA

Contributor
Submitted by techrev on Thu, 12/29/2016 - 09:49

Create Custom Commands for Excel - VBA

You can create Custom Commands for Excel to perform some predetermined operations. These commands can be entered directly inside a cell to do the required actions (calculations)

Please note that, these commands are made on VBA, so please refer our previous articles for the basic idea on Macros and VBA

Example Command : ADD

Command to ADD to values from columns A and B and display in C, the command “ADD” will be typed in cells of Column C

Steps :

Tags