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