OzGrid

Excel Visual Basic Editor Environment Tips & Tricks

< Back to Search results

 Category: [Excel]  Demo Available 

Excel Visual Basic Editor Environment Tips & Tricks

 

Got any Excel/VBA Questions? Excel Help


Activate the VBE-Visual Basic Editor

Push Alt + F11

Go back to Excel:

Push Alt + F11 to toggle between Excel and the VBE.
or Alt + Q to quit the VBE.

Go to Workbook Events:

While in Excel Right click on the Excel icon, top left next to "File" and select "View Code". Then choose an Event from the "Procedure" drop down list box. For Excel 2000 you will need to select "Workbook" from the "Object" drop down list box.

Go to Worksheet Events:

Right click on any sheet name tab and select "View Code". Then choose an event from the "Procedure" drop down list box. For Excel 2000 you will need to select "Worksheet" from the "Object" drop down list box.

Getting quick help on an Excel Property, Procedure, Event or Keyword:

Place you mouse insertion point anywhere within the text and push F1.

Customize the VBE Toolbar:

Right click on any blank area of the Toolbar and select "Customize" then click the "Commands" page tab and drag menu items on or off.

Lock/Protect VBA code from viewing

Go to Tools>VBAProject Properties... select the "Protection" page tab, check the "Lock project from viewing" check box. Type in a password in the "Password" box then type in again in the "Confirm password" box. and click Ok. You will need to Save and close the Workbook for the protection to take place.

Placing special symbols into your message boxes and Inputboxes:

Degree symbol = Alt+0176
At sign = Alt+064
Copyright sign = Alt+0169
Registered symbol = Alt+0174
One quarter as a fraction = Alt+0188
One half as a fraction = Alt+0189
British Pound sign = Alt+0163
Three quarters as a fraction = Alt+0190 
To get the full list type "Character Set (128 255)" into the help wizard while in the VBE

 

 

See also:

Index to Excel VBA Code
Index to Excel Freebies
Excel: Delete/Deleting Blank Rows With Excel VBA
Excel VBA Events
Excel VBA Intersect Method
Excel VBA Loops

 

See also Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions.

 

Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.

Cricket is one of the most popular sports in the UK, Australia and India. There are more than 100 countries that are members of the International Cricket Council. People who want to bet on cricket games in online cricket betting and in betting shops must choose the right site. We'll cover information about the types and odds of betting on cricket along with some of the major betting events. Bet online or with friends and there is some cash if you understand the sport.

Gallery



stars (0 Reviews)