VBA Enterpad for Excel & Word for Windows
Ready to get up to speed with your new Enterpad? You are at the right place. The goal of this 10-minute tutorial is to create a key on the Enterpad to change (for green) the background color of cell(s) in Excel. Then, you will be ready to set up your own macros using your VBA knowledge. Eventually, you could end up with an overlay like this (with a pencil and an eraser).
What you will need
This tutorial assumes that Excel for Windows (with VBA support) is installed on your computer.
An overlay sheet
1. Write on your overlay sheet.
If the overlay sheet is already on the Enterpad: Lift the bottom tab of the Enterpad and remove the overlay sheet. You must remove the overlay sheet from the Enterpad to write on it.
Within the rectangle of the key number "001" (top-left corner) on your overlay sheet, write (with a pencil) "Fill Green". Should you have to erase, take care to clean the overlay sheet of eraser residue, as it may affect touch sensitivity.
Lift the bottom tab of the Enterpad and put the overlay sheet under the sheet cover (with the key number "001" at the top left corner of the Enterpad.
2. Copy/paste the following macro in your Excel file:
It is probably best to put your macros inside a regular code module in your Excel file. To create one, click on Insert>Module from the Visual Basic Editor (Select the right Workbook before if you have more than one opened). Then paste the following code in the code module:
Sub EP_1() With Selection.Interior .Pattern = xlSolid .PatternColorIndex = xlAutomatic .Color = 5296274 .TintAndShade = 0 .PatternTintAndShade = 0 End With End Sub
The name of the macro (at line 1) is "EP_1". This is the name of the macro the Enterpad is looking for when you press its first key. The Enterpad will look for "EP_2" if you press its second key, "EP_3" for its third key and so on.
Press the first key on the Enterpad to apply the fill color (green) to the selected cell(s).
Need some ideas to get started?
Are there keys on your Enterpad that are waiting for a useful purpose? Or you simply want to start a script from an existing one? We offer a collection of useful scripts to start from: Useful Macros