On Mar 19, 9:06*am, Jim Thomlinson <James_Thomlin...@owfg-Re-Move-
This-.com wrote:
"Ambiguious Name Detected" has to do with naming two procedures or functions
the same, or declaring 2 identical variables in the same procedure or global
declarations. Duplicate variable declarations normally generate a "Duplicate
Declaration in Current Scope" error.

'Global declarations in one module or one procedure
Dim x as string
Dim x as long 'Ambiguious Name Detected

'Procedure
sub test(byval x as string)
dim x as string 'Duplicate Declaration in Current Scope
end sub

These examples are fine
Dim x As String 'in module 1
Dim x as String 'In module 2

sub Test() in module 2
dim x as long 'local declaration of x where x is also global
end sub
--
HTH...

Jim Thomlinson



"Chet" wrote:
I am getting "ambiguous name detected" error message when *try to run
some code that has a form in it. *Is it the case that if I have
multiple different forms in my personal.xls (each form is for
different code also within personal.xls) that all variable names have
to be different?

I was thinking that among different forms in the personal.xls that
there could be name duplications as long as I didn't try to use the
two forms that have the duplications in the same code.

Thanks, *Chet- Hide quoted text -

- Show quoted text -

I should simplify my question. Can I have the same variable name in
multiple different "forms" inside my personal.xls?