Affiliates

Amazon.com


Popular Microsoft Excel Books

Excel 2003 Bible
Excel 2003 Bible
Author: John Walkenbach 

Excel 2003 for Dummies
Excel 2003 for Dummies
Author: Greg, PhD Harvey 

Microsoft Office Excel 2003 Step by Step
Microsoft Office Excel 2003 Step by Step
Author: Curtis Frye 

Excel VBA Programming For Dummies
Excel VBA Programming For Dummies
Author: John Walkenbach 

Excel 2003 Personal Trainer
Excel 2003 Personal Trainer
Author: Inc 

Microsoft Office Excel 2003 Inside Out
Microsoft Office Excel 2003 Inside Out
Author: Craig Stinson 

Excel 2003 All-in-One Desk Reference for Dummies
Excel 2003 All-in-One Desk Reference for Dummies
Author: Greg Harvey 

Popular MS Excel Related Websites

Microsoft Corporation 













Microsoft Excel 2007 Tutorial for beginners    

Welcome to MS Tips and Tricks
Welcome to MS Tips and Tricks - You are at the right place if you need tutorials for beginners - Online Microsoft Excel tutorials for beginners, covering the following categories - Advanced Formulas, Pivot data, Charts, Databases, Customization, Table, Forms, etc.,

  Microsoft Excel Tips and Tricks for beginners

 
14) Delete the last two lines.
 
Illustration 8: Error Message.  Click here to view larger image.
 
15) Write an Information message by adding a new line.
MsgBox "Pivot Table data has been refreshed", vbExclamation + vbInformation, "Macro Finished".
 
Illustration 9: Warning message.  Click here to view larger image.
 
16) Close the editor and run the macro again.
 
17) See the results.
 
Illustration 10: Information Message.
 
18) Select the View Macros command from the Macros Group in the View tab in the Options Tape.
 
19) Select the SampleMacroForPivotUpdate macro and press the Step Into button.
 
20) The Visual Basic for Applications code editor will be opened. The macro code will be displayed with a yellow bacground over the macro name.
 
Illustration 11: step into code.  Click here to view larger image.
 
21) Press the F8 key. The cursor will advance to the next executable code line.
 
22) Press F8 key twice again.
 
23) Run the Refresh sentence.
 
Illustration 12: Execute the line with F8 key.  Click here to view larger image.
 
24) Debug each line to see the final results.
 
25) Close the VBA code editor.
 

 
Advertisement



Advertisement



Copyright MS Tips and Tricks
A Division of Gurijala and Company, 2006
Home - Tips and Tricks - Resources - Links - Contact - Site Map - Privacy Policy - Email Webmaster