View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Chet Chet is offline
external usenet poster
 
Posts: 88
Default 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.