Most valuable professional
  • Hot Topics

Excel Declaring public variables

Is it good practice NOT to declare variables publically but instead define a class? So in place of this in a standard module: Code: Public use this in MyClass Code: Private Public FileNumber End Property Public mintFileNumber End Property but I still need to add this in a standard module: Code: Global Thanks

This question generated 10 answers. To proceed to the answers, click here.

This thread is current as of October 1, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel