Dim?

[iwilli]

New-ish guy back again. Will someone in plain English tell me what is DIM in VBA and why do you use it?

[royUK]

DIM is short for Dimension, you use it to declare variables.

[MrShorty]

And declaring variables allows the programming to reserve memory for the information, to know how much memory to reserve, and to know what type of information that variable will hold. This will allow the programming to use memory and processor time more efficiently, causing your code to run faster.

[iwilli]

Thanks now I know what they are. How are they used? Or where can I go to learn more about how to use them?

[Mordred]

The following code declares variables

Please Login or Register  to view this content.

What I find to be most valuable about declaring variables is that it helps to enable the intellisense while coding. If you want to test the intellisense, re-write the code I gave line by line and you'll see what i mean.

[Mordred]

Also, by declaring Option Explicit at the top of each module, you will be forced to declare variables, which helps a lot. For instance, with the same code as the previous post:

Please Login or Register  to view this content.

[royUK]

There's some notes that I put together here

[iwilli]

Thanks everyone. This really helps me understand dim and how to use it. This is awesome.

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save