What are Dim, Modifier and Sub ( ) vs Private Sub ( )?

**caabdul** · 01-26-2014, 03:13 PM

Hi,

I know above are the things explailed all over the web and one does not need much google to find these.

But nobody has explained these things for a layman who is new to programing world.

I have made some good macros but still I don't know what are following things;

1- What the _ell is the dim word? What if it were never born?

2- Why do we call them modifiers?

3- Why some people prefer to write Private Sub Name() instead of simply writing Sub Name()

Please explain above things to a layman.

(I am not

a lay man)

**mehmetcik** · 01-26-2014, 04:05 PM

Selam.

Dim is short for Dimension. You are declaring a variable.

Most of the time you do not need to use it and your macro will work.

However. If you are using arrays it is a good idea to dimension it before you try and use it.

a macro with the name format

Please Login or Register  to view this content.

can be called manually, through a command button or from another macro.

a macro with the name format

Please Login or Register  to view this content.

can only be called from within Visual Basic maybe by another macro or a command button on a user form. They cannot be called manually as they do not appear on your run macro list.

This is useful because if you had every Macro on your run macro list you could not cope. For example in some userforms I can have 100 command buttons and text boxes.
If each associated macro were on your run macro list you could not cope.

**caabdul** · 01-26-2014, 04:19 PM

I didn't get to the dim but your explanation for Private Sub () is much appreciated! Thank you

**protonLeah** · 01-26-2014, 04:45 PM

Dim is one of the ways to allocate the computer's memory. The amount of memory allocated will depend on the TYPE that you declare the variable as (e.g. Long, Integer, Double, String, ...). You should always Dim every variable you use in your macros; also you should always use OPTION EXPLICIT at the top of the module before any sub's. If you do not, then misspelling a variable in you code will always cause VB to create a new (different variable than the one you thought you were using).

**caabdul** · 01-26-2014, 05:01 PM

Pro! Your explanation for dim was PRO. Thank you

I hope there is no other functioning of dim except that it makes the code memory efficient, that is what I understand.

But, I don't remember when I asked about OPTION EXPLICIT.

**caabdul** · 01-26-2014, 05:03 PM

Now what is this OPTION EXPLICIT

**protonLeah** · 01-26-2014, 05:12 PM

OPTION EXPLICIT
causes VB to post an error message ("variable not defined") if you try to use a variable that has not been Dim'd (maybe because of a misspelling). Also, if you try to assign data to variable which does not match the TYPE in the Dim statement you will get an error ("type mismatch"). For instance if you define, say TOTALCOUNT as Long, then somewhere in your code you say: TOTALCOUNT= "testing 123" (a string) you will get that error.
OPTION EXPLICIT makes troubleshooting code much easier and you should insist on using it always.

**caabdul** · 01-26-2014, 06:51 PM

Hmmm! It means OPTION EXPLICIT is really

Thank you PRO Sir!

**caabdul** · 01-27-2014, 11:16 PM

I have seen the following macro name;

"Public Sub Initialize(ByVal Number As String, ByVal name As String, ByVal Importance As String, ByVal Estimation As String, _
ByVal Note As String, ByVal HowToDemo As String, ByVal Complete As String)"

Is this some new gener?
Also, I have learned that a macro name can't contain spaces, but above is working fine. How?

**protonLeah** · 01-28-2014, 03:05 AM

The name of the macro is 'Initialize" there are no spaces,
It is subroutine and not a User Defined Function
It is being called by some other macros in the project which pass it values (ByVal Number as String, ... ) to operate on.

**cytop** · 01-28-2014, 04:28 AM

Which raises the question: "What's this ByVal thing...?"

Might suggest the OP would benefit from having a read of Chip Pearsons' introduction to VBA. In particular:

Declaring Variables (Includes the use of 'Option Explicit'
Scope of Variables and Procedures
Passing Variables ByRef and ByVal

And, as a bonus for when he really gets into it:

Error Handling in VBA

The index page is here

(I would have included direct links except for the limit imposed by the board - instead listed the topic titles as they appear on the Index page.

**caabdul** · 01-28-2014, 09:18 AM

cytop! are you asking something or explaining something?

What are Dim, Modifier and Sub ( ) vs Private Sub ( )?

LinkBack

Thread Tools

Rate This Thread

Display

What are Dim, Modifier and Sub ( ) vs Private Sub ( )?

Re: What are Dim, Modifier and Sub ( ) vs Private Sub ( )?

Re: What are Dim, Modifier and Sub ( ) vs Private Sub ( )?

Re: What are Dim, Modifier and Sub ( ) vs Private Sub ( )?

Re: What are Dim, Modifier and Sub ( ) vs Private Sub ( )?

Re: What are Dim, Modifier and Sub ( ) vs Private Sub ( )?

Re: What are Dim, Modifier and Sub ( ) vs Private Sub ( )?

Re: What are Dim, Modifier and Sub ( ) vs Private Sub ( )?

Re: What are Dim, Modifier and Sub ( ) vs Private Sub ( )?

Re: What are Dim, Modifier and Sub ( ) vs Private Sub ( )?

Re: What are Dim, Modifier and Sub ( ) vs Private Sub ( )?

Re: What are Dim, Modifier and Sub ( ) vs Private Sub ( )?

Thread Information

Users Browsing this Thread

Similar Threads

Change result of applying modifier

[SOLVED] Using a NOT modifier within Search()

Modifier based sum

Key modifier to toolbar button -- HELP

Key modifier to toolbar button ??

Bookmarks

Bookmarks

Posting Permissions