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

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, LLC
www.cpearson.com
(email on web site)



"Chet" wrote in message
...
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

On Mar 19, 11:57*am, "Chip Pearson" 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" wrote in message

...



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.

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" wrote in message
...
On Mar 19, 11:57 am, "Chip Pearson" 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" wrote in message

...



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.