I was referring to having variables with the same name in *object modules*
(Class modules, ThisWorkbook, the Sheet modules, Userforms), not duplicating
names in standard modules. I would strongly recommend that you *not* have
duplicate names in standard modules unless those variables are declared
Private to the module.
--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
"Chet" <(E-Mail Removed)> wrote in message
news:45536d2f-5e12-4e95-9b53-(E-Mail Removed)...
On Mar 19, 11:57 am, "Chip Pearson" <c...@cpearson.com> wrote:
> Yes, it is perfectly legal to have variables with the same name in more
> than
> one form or other type of object module.
>
> --
> Cordially,
> Chip Pearson
> Microsoft Most Valuable Professional
> Excel Product Group
> Pearson Software Consulting, LLCwww.cpearson.com
> (email on web site)
>
> "Chet" <chetshan...@gmail.com> wrote in message
>
> news:648f8eee-dd15-4c47-b650-(E-Mail Removed)...
>
>
>
> > Can I have the same variable names in multiple different "forms"
> > inside my personal.xls? In other words in form1 I have a variable
> > called SaveToDesktop adn in form2 I also have a variable called
> > SaveToDesktop.
>
> > Is this OK to have the same variable name in two different user forms
> > in the same personal.xls file? This "variable" represents a control
> > in each form.
>
> > Thanks,
> > Chet- Hide quoted text -
>
> - Show quoted text -
Thank you Chip... I will investigate further. I am getting an
"ambigbuous name detected" message and thought that might be the
name. Oddly though when I did make the variable names different in
each form code section the ambiguous name error message did not occur.
Similar Threads
