Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I have the same variable names in multiple different "forms"inside my personal.xls?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I have the same variable names in multiple different "forms" inside my personal.xls?
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I have the same variable names in multiple different "forms" inside my personal.xls?
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Range("C100:D200").Select with variable names | Excel Programming | |||
Question on determining "ROW" inside of a "For .. RANGE " loop | Excel Programming | |||
Listbox header inside VBA (Array("Head1", "Head2", ...) | Excel Programming | |||
using a "variable" in range names | Excel Discussion (Misc queries) | |||
use variable in Workbooks("book1").Worksheets("sheet1").Range("a1" | Excel Programming |