Create Custom Commands for Excel - VBA

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 :


Search and Display the contents of Access database inside a VB Form

You can display the contents of Access database inside a VB Form using DataGridView controls (from the tool box)


Add a textbox, a button and a data grid view

Double click on the form and add below codes (This code will search for textbox1.text value in database and display all tables inside datagrid view). Put the database (database.accdb) inside debug folder

In this example, assume there is a column called F2 inside table1 of database.accdb

CAAadmin Wed, 09/07/2016 - 05:24
Arduino VB.NET Simple Keypad Reader
Arduino VB.NET Simple Keypad Program - to connect VB interface and simple external keypad via Arduino please use our support forum for questions
CAAadmin Sun, 07/24/2016 - 07:58
How to use simple keypad with Arduino
Example program to link your arduino to Simple keypad
CAAadmin Sun, 07/24/2016 - 07:12