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
