- Msgbox
- Select Case
- If Then End if
- Dim
- Inputbox
However, each program also has its own commands peculiar to that program. For example, in Excel you need to know how to refer to a cell on a worksheet, this obviously only applies to Excel as no other application has cells in a worksheet. In Word there is a command that specifically refers to a sentence. So in order to learn about Visual Basic for Applications you first need to choose a Microsoft Office Application (such as Word or Excel) to start with, the most common application used is Microsoft Excel.
You then need to be introduced to the Visual Basic Editor (VBE) which is where you will write your Visual Basic for Applications code or programming statements. Once you understand how the Visual Basic Editor works for one Microsoft Office Application, you will be able to use it in the same way for all the Microsoft Office Applications, thus you don’t have to learn that again and once you learn the Visual Basic commands that are common between all Microsoft Office Applications you will have a foundation for the other applications as well.
"This is my second course and I have enjoyed both and have another booked for February so I wouldn't change anything"
"Knowledge and professionalism of the trainer was excellent, questions encouraged and answered knowledgeably"
"Today I've had the most enjoyable and informative training session of my professional career, can't say more than that!"
"Very well presented, easy to follow and trainer willing to answer any questions."
"I found the course to be very valuable and will definitely be able to put my new skills into action in my job."
"Excellently presented. Never felt rushed or out of depth. Trainer very helpful."
"Course both covered the syllabus and was flexible enough to be tailored to our specific needs in certain areas"
"Learnt above and beyond what I expected, made very welcome which led to a good working atmosphere"
"Amazing! Fountain of knowledge!"
"Great experience, really worthwhile once again"
"Very good way to teach. Nice mix of theory and practice"
