Can I have the same variable names in multiple different "forms"inside my personal.xls?
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.
|