Public variable not visible!!!!!!!!

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I hope someone can help me.
I am doing a VBA project and declaring a variable
as "public" in the Declarations section of a module.
However, the variable is not visible to other modules in
the project despite the fact that the variable is not
declared anywhere else in the project.
To test further, I did a simple two-module project with a
simple macro in each module. The public variable is still
not being recognised in the second module.
Thanks a million in advance.
Tom
 
Have you declared Option Explicit? If not, do so. It may help point
something out, like spelling.
 
-----Original Message-----
I hope someone can help me.
I am doing a VBA project and declaring a variable
as "public" in the Declarations section of a module.
However, the variable is not visible to other modules in
the project despite the fact that the variable is not
declared anywhere else in the project.
To test further, I did a simple two-module project with a
simple macro in each module. The public variable is still
not being recognised in the second module.
Thanks a million in advance.
Tom
.
I solved this since I left the post. So disregard the
post.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top