Code Organization & Variable Scope

[slwolf8]

(I am new to VBA)

I wrote a program that accepts some information from users and then creates a document, a post card, and a mailing label. Currently, I have different procedures for each of those. Is it ok to organize it that way and use public variables? I ask because I understand public variables should be used sparingly. Is there a better way to organize this? Should I be using modules (I don't know much about module use).

Thanks!

 

[AgatheB]

Hi Slwolf8,

Modules are OK. If you are nervous about your public variables than you could set them as 'static values', using a general workbook that always operates in the background where you have your code writing down values, you can call at any time.

Agathe