The VBA Environment
Developer Tools on Excel
Developer Tools on Access
Developer tools on PowerPoint
Demo of Developer Tab on Excel
To Switch between Application and VBA Edit press ALT + F11
Macro Security
The Macro Recorders
With the Option of “USE Relative Reference”, macro can be executed on any selected cell
The Visual Basic Editor
The Properties Window
The Debugger
F9 will mark current position in break point
F8 will perform step into operation in break mode
Shift + F8 will perform Step Over operation
CTRL + SHIFT + F8 will perform Step out operation
Immediate window will help to execute the VBA code immediately with the help of Debug object
Locals windows will be used to display the expression values of current context of program
Watch will be used to view current context expression values as well as used for Conditional Break Points.
CALL Stack window is used to display the Called and Calling information of Program context
Compiling the VBA Project
This operation will convert current code into P-Code format which will be executed in Virtual Machine of Application. There is no way to create Stand alone executable using VBA…
Some Useful add ins site for VBA Developers
The VBA Language
This will give the Intellisense support for VBA Development
Event Declaration Syntax
The Object Model
To make a default properties of Collections
The Event Model
User form Events
Debugging and Error Handling
Demo of Error handling
Putting All together
Demo of Custom Ribbon
Blogger Labels: Fundamentals,Environment,Developer,Tools,Excel,PowerPoint,Demo,Switch,Application,Edit,Macro,Recorders,Option,Relative,Reference,cell,Visual,Basic,Editor,Properties,Debugger,mode,Shift,Step,Over,CTRL,Immediate,Debug,Locals,context,Watch,Conditional,Break,Points,CALL,Stack,information,Program,Project,Code,Virtual,Machine,Stand,Some,Useful,Developers,Language,Intellisense,Development,Event,Declaration,Syntax,Object,Model,Collections,User,Events,Error,Custom,Ribbon
