Anyone use VBA in Excel: eclaring Arrays as Public

  • Thread starter Thread starter Saladsamurai
  • Start date Start date
  • Tags Tags
    Arrays Excel
Click For Summary
The discussion centers around the use of VBA in Excel, specifically regarding the declaration of arrays as Public. A user encountered an issue with their code, which was not functioning as expected. After investigation, it was discovered that the problem stemmed from writing the code in a sheet instead of a module. This highlights the importance of understanding the correct context for declaring Public arrays in VBA to avoid common errors.
Saladsamurai
Messages
3,009
Reaction score
7
Anyone use VBA in Excel::Declaring Arrays as Public

Egads man...I have seen plenty of modules with arrays declared as Public. Clearly I am making some boneheaded error here and cannot locate it:

ExcelError.jpg


Any Thoughts?
 
Technology news on Phys.org


Solved:

After some searching I found that the error is because I wrote my code in a sheet and not a module... :/
 

Thread 'For those who ask: "What programming language should I learn?"'

Learn If you want to write code for Python Machine learning, AI Statistics/data analysis Scientific research Web application servers Some microcontrollers JavaScript/Node JS/TypeScript Web sites Web application servers C# Games (Unity) Consumer applications (Windows) Business applications C++ Games (Unreal Engine) Operating systems, device drivers Microcontrollers/embedded systems Consumer applications (Linux) Some more tips: Do not learn C++ (or any other dialect of C) as a...
View full post »

Similar threads

C/C++ Passing a VBA array to a C++ dll - Example Needed
  • · Replies 3 ·
Replies
3
Views
8K
Java Please help explain the reason for the errors displayed for my Java code
  • · Replies 8 ·
Replies
8
Views
2K
Polymorphism using pointer to array
  • · Replies 23 ·
Replies
23
Views
2K
Java What is wrong with my Java array and methods code?
  • · Replies 13 ·
Replies
13
Views
4K
Arrays/vectors without knowing type
  • · Replies 12 ·
Replies
12
Views
2K
Question about the efficiency of using an array or individual variables
  • · Replies 235 ·
8
Replies
235
Views
14K
C/C++ Question about New syntax of C++
  • · Replies 31 ·
2
Replies
31
Views
3K
Python Differences between Pillow and Pyplot in turning an array into an image
  • · Replies 6 ·
Replies
6
Views
3K
Java Recursively sorting an array of strings w/o aux. parameter
  • · Replies 7 ·
Replies
7
Views
3K
What are the Values of Machine Constants in Excel/VBA?
  • · Replies 2 ·
Replies
2
Views
3K