VBA IDE Weirdness....
Hello Trip
This error usually occurs when a object name
(/function/macro/variable/etc...) is used twice within a project but
referring to (at least) two different objects.
HTH
Regards
Pascal
"Trip" a écrit dans le message de
...
Hello all,
A little weirdness occurred with my VBA development environment and I was
wondering if it is anything to be concerned about...
I had CommandButton1 on a sheet and a corresponding "Sub
CommandButton1_Click()" routine in VBA. Somehow, the name of the button
was
changed to CommandButton2 - not by me, and I'm the only one writing code
on
this workbook. Yet the routine's name did not change. Obviously, the
button stopped working. When I went to change it's name back I would
immediately get an error about "Ambiguous Object Name" (or something very
close to that). Ultimately, I had to change the name of the routine.
I scanned the workbook for viruses, and found nothing. Does anyone have
any
ideas as to what happened.
Thanks!
Trip
|