VBA Procedure
How To Declare A Variable With VBA Dim
To declare a variable, means to allocate a portion of the computer’s memory to hold the contents of that variable. “Dim” means “Dimension”, or “allocate a portion of the computer’s memory.” “Dim intNumber As Integer” – means that we need the computer to allocate 2 bytes of the computer’s total RAM memory to hold a […]
How To Make An InputBox In VBA
The input box is a great way to retrieve and process input from your user. In the following example we’ll control program flow based on the user’s input in the inputbox. Your user will enter a text value and we will evaluate their answer and send them in the right direction. Sub InputboxVBA() Dim strAnswer […]
Free Access programming tutorial Video 1
In this part of the video series you’ll learn the following: Writing VBA Procedures Overview Of VBA Modules And Procedures Working With VBA Modules The VBA Code Window Creating A VBA Sub Procedure Working With VBA Variables Declaring Variables In VBA Overview of Modules and Procedures: Statements -> Single lines of programming code that performs […]