No Image Available

TrainingZone

Read more from TrainingZone

googletag.cmd.push(function() { googletag.display(‘div-gpt-ad-1705321608055-0’); });

VB or VBA?

default-16x9

I have been asked by someone to look into VB or VBA training. They don't really know which they mean...nor do I!I work mainly with the lower levels of office applications and don't know the diference between VB and VBA. I would like a breakdown of tasks covered in each which I can use when I assess their training requirements face to face.

Cathy Gillespie

2 Responses

  1. VB or VBA training
    We think they mean Visual basic or visual basic advanced training. This is a specialisd field and we think you should find out a lot more about why they think they need it before seeking to analyse how it can be taught.

    It is unlikely to be needed for normal commercial use unless someone is a programmer and wishes to introduce applets into Word or Excel.

    We hope this helps and you can convince them that the packages you are familiar with are sufficient. if not then come back to us and we will assist you to source the help you need.Contactt [email protected] for further details.

  2. VBA is probably what they want
    VB (Visual Basic) is a programming language which allows the creation of stand alone programs that can do virtually anything. VBA (Visual Basic for Applications) is a sub set of VB customised for a particular application (e.g. Word, Excel). It is used to add functionality to these programs (e.g. to auomate repetitive tasks). If they are no sure what they wantthen it is almost certain that they don’t want VB! To get the best of a VBA course they would need to be at a fairly advanced level with the individual application. Most FE colleges run VB courses at City and Guilds basic level over about 12 weeks (one evening a week) and if they want to get a taste of VB this is probably the way to go. It did sound to me though, judging from what you said about their level of skill, that they need to do an advanced applications course first (e.g. word asdvanced). This would teach them how to use Macros to automate proceses and would be an ideal introduction to VB (macros convert the keystrokes entered to VBA so you can see how the code works without knowing programming). Hope this helps. If you need any other help, feel free to email me at [email protected].

Newsletter

Get the latest from TrainingZone.

Elevate your L&D expertise by subscribing to TrainingZone’s newsletter! Get curated insights, premium reports, and event updates from industry leaders.

Thank you!