Dim, Public, Private MyVariable As String

**esbencito** · 10-11-2018, 04:22 AM

Hi all,

How can I make below variables available in all my modules? They won't ever change unless the filename changes and I need to refer to them in several modules. I'm not familiar with the different type of variable definitions as I always use "Dim", not sure what "Global", "Public", "Private" and all the others do. Would appreciate if someone could explain the difference and usage...

Please Login or Register  to view this content.

**romperstomper** · 10-11-2018, 04:24 AM

I suggest you read this: http://www.cpearson.com/Excel/Scope.aspx

**esbencito** · 10-11-2018, 04:57 AM

Thanks! Don't seem to get it right though. Below is what I've done now in one of my modules, but when I run a procedure in another module with these variables, it says "variable not defined"...

Please Login or Register  to view this content.

**romperstomper** · 10-11-2018, 05:12 AM

Which module did you declare the variables in? It should be a normal module.

**esbencito** · 10-11-2018, 05:46 AM

Ups... had it in a UserForm! Now it works!! Thanks!

Dim, Public, Private MyVariable As String

LinkBack

Thread Tools

Rate This Thread

Display

Dim, Public, Private MyVariable As String

Re: Dim, Public, Private MyVariable As String

Re: Dim, Public, Private MyVariable As String

Re: Dim, Public, Private MyVariable As String

Re: Dim, Public, Private MyVariable As String

Thread Information

Users Browsing this Thread

Similar Threads

Parameters to Function and Using the Public/Private

Macros saved private - to public

Public vs Private?

[SOLVED] Private Sub Workbook_Open() Vs Public Sub Auto_Open()

Convert this private sub to public sub to work

Public or Private Variable

Option Explicit function and private/public/dim

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions