Du pli cate Vari ables
When we de clare our variables at the be ginning of a mod ule, we cre ate a
box
to put in formation in, and we give that box a name. What if two boxes have
the same name? That would be a prob lem, and VBA would not know what to do.
In fact, noth ing in your module would work at all. You could have buttons tied to
procedures that have noth ing to do with the variable that is de clared twice, but
they would not work. Noth ing would work.
You might have this problem if you are combining
two examples or have a
long list of variables that you de clare at the beginning of your module, and you
forgot you al ready de clared a vari able. If none of your VBA works,
check the
variable dec larations at the beginning of the mod ule and de lete any du plicate
Do'stlaringiz bilan baham: