Relative Content

Tag Archive for vba

Which programming designs leads to more problems?

As a fresh programmer, one of the first thing for me to learn was to learn language and its syntax. Now my next training issue is to design my code heirarchy in such a way it is simple to maintain over time. One example I just encountered is below. It is in VBA for Excel but the concept extends to other languages too.

How can I declare my variables as public in VBA?

I am using vba for the first time in a internship, so maybe this is basic but I can’t seem to make my variables public… I have tried to create a global module where I declare them as public, the ones I want to use in other places besides the UserForms where they are being used now.