01270 765500

Training Needs Analysis

Word VBA

This questionnaire helps you assess your current skill level, which helps us choose the most suitable course

Please mark each question from 1 to 10. 10 meaning a complete understanding and 1 indicates no previous knowledge. The 'Ability' column is your current knowledge and the 'Need' column indicates how important a topic is to you.

If you do not know what the topic refers to then leave the Need column blank.

*Name: Email:
Company: Phone:


  Ability Need
Have you ever recorded Word macros?
Do you know how to access the Visual Basic Editor to make minor changes to macros?
Do you understand the significance of the location of macros within documents, templates, Normal.dot and other global templates?
Can you create and modify templates and forms?
Do you understand the basic layout and syntax used in the Visual Basic Editor?
Can you modify your Quick Access toolbar to give access to your macros?
Can you create variables in your code?
Can you make a macro call another macro?
Do you know how to declare variables of different data types?
Can you create a macro which toggles a feature (on and off)?
Can you get simple user input to be included in your macro?
Can you create conditional statements in your code (IF, THEN, ELSE statements)?
Can you add loops to your code (FOR or WHILE loops)?
Can you use Cases within your code?
Do you know how to compile your code before running a macro?
Can you use break points in your code?
Are you aware of Auto macros that you can create?
Can you include error handling routines in your macros?
Can you create basic dialogue sheets to be displayed and used by your macros?
Can you create and populate combo boxes within your user forms?

Ability Total


Need Total


Each question where your NEED is greater than your ABILITY will make this course more useful to you. When these rows total over 50, the course is recommended. 0

Cancel and return to list of Needs Analysis forms.

View the related course outlines

Login form