Excel With VBA

This is an example of the VBA Procedure: Scope is an important topic when it comes to VBA procedures. The topic of scope deals with what can “see” the VBA procedure. Can the workbook “see” the VBA procedure? Can only the modules in the VBA procedure see the VBA procedure? VBA Procedures can be “Private”…

In Excel the steps needed to perform a series of actions can be recorded as a macro. In the previous lesson we looked at the before and after shots of the macro window. Here is an image of the Standard VBA Toolbar, which you will see in all editors of VBA It is beneficial to…

The main thing to remember when you are trying to figure out how to write a program is to think logically, and draw the flow of events on paper. Your goal is to take your thought process and translate it to Excel VBA code. Each video in the Excel VBA tutorial will highlight one of…

This is an example of the VBA Msgbox (message box): Public Sub NewMsgBox() Dim strMsg as String ‘Allocate a portion of memory for a string ‘(text – up to 255 characters) holding variable strMsg = “Press enter to continue” Msgbox strMsg End Sub That’s all, I hope it helped! Let me know if you have…