Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ambiguous name detected - help how fix?
I am getting an error when I click the cancel button on my userform
and I know what it means but I don't know for sure how to fix it. The error message is "Ambigous name detected: RunStatus" I have a user form and one option is to "cancel" out of the userform. The cancel button is associated with a commandbutton control and in that commandbutton I use the following code. Private Sub CommandButton2_Click() Unload FWRdataSortSubTtl RunStatus = False End Sub This code then goes back to the main module (I hope it does anyway) after the userform is unloaded. At this point the code should take me to the end of the main module with the following code. 'SHOW THE DATA FORM RunStatus = True FWRdataSortSubTtl.Show If Not RunStatus Then GoTo TakeToEnd I do something like this where I use the RunStatus variable in most all of my other main modules in personal.xls but I thought those other instances of RunStatus were unique to those modules and would not interfere with this instance. Any clues what I might be doing wrong? Like I said I know what the error means but am not sure how to fix it since I didn't think I had any duplication of the use of the variable name in the scope of what I am doing. Thanks, Chet |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ambiguous name detected - help how fix?
Sounds like you have 2 macros with the same name or two variables with the
same name. You can try to eyeball it and find the problem or maybe you should copy/paste your code to a notepad, delete what you have, and start over...if the overall code, modules, useforms, etc., is relatively easy to recreate. HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Chet" wrote: I am getting an error when I click the cancel button on my userform and I know what it means but I don't know for sure how to fix it. The error message is "Ambigous name detected: RunStatus" I have a user form and one option is to "cancel" out of the userform. The cancel button is associated with a commandbutton control and in that commandbutton I use the following code. Private Sub CommandButton2_Click() Unload FWRdataSortSubTtl RunStatus = False End Sub This code then goes back to the main module (I hope it does anyway) after the userform is unloaded. At this point the code should take me to the end of the main module with the following code. 'SHOW THE DATA FORM RunStatus = True FWRdataSortSubTtl.Show If Not RunStatus Then GoTo TakeToEnd I do something like this where I use the RunStatus variable in most all of my other main modules in personal.xls but I thought those other instances of RunStatus were unique to those modules and would not interfere with this instance. Any clues what I might be doing wrong? Like I said I know what the error means but am not sure how to fix it since I didn't think I had any duplication of the use of the variable name in the scope of what I am doing. Thanks, Chet |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ambiguous name detected? | Excel Discussion (Misc queries) | |||
Ambiguous Name detected? | Excel Programming | |||
ambiguous name detected | Excel Programming | |||
Ambiguous Name Detected | Excel Programming | |||
Ambiguous Name Detected:~ | Excel Programming |