Understanding scope

[medic5678]

In order to have a variable visible to all controls in a particular form, does it need to be global? Is there a way to declare a variable to have the scope of all procedures triggered by controls in a from, or would you need to put all the code for the subroutines in a module, with a module scoped varaible?

assuming userform1 with 10 controls, all manipulating the same array.

When the form in initiated, can you declare the array there, in such a way that all the controls would have access to the array, but the array wouldn't have scope to anything outside the form?

 

[Jaafar Tribak]

The people here have been phenomenal. When you're new to this, you have no clue how to get started. I've tried to take VBA classes, but I just can't suffer through them, as my internet is so lousy (satellite, I live in Timbuktoo) I can't watch the videos without constant stopping/stalling. There's no substitute for doing and to be able to ask a question here and have someone take time to answer it (clueless newbies can be dumber than rocks), is an enormous help. Actually just a few days away from finishing my first VBA application. It's all starting to gel.

True.

Although I am longtime user of excel/vba and a veteran member in this forum, I am still amazed at the number of knowledgeable and friendly people that come here from different countries and cultures with a shared goal of willing to offer their expertise to help others.... I personally learnt a great deal here and owe this forum most of what I know by answering questions and by reading other member's answers.

I am happy you had a pleasant visit here and wish you all the best with your learning process.