|
Go to the lower left hand corner of the screen, right click on the name of your sheet, and pick "View
Code" [Fig. 1]
If that was unsuccessful, you may not have requested that the VB tools be included when you installed
Office. (Hint: if you did a standard install you probably didn't).
Go ahead and reinstall; if you have problems go see Micro$oft
Office support.
Next, insert your own module. Right click on the VBAProject for your file (here it is "Book1")
and choose "Module." (You may need to run View/Project Explorer to see the window on
the left.)
Now you should see the following screen; go ahead and punch in a simple function.
|
