ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA IDE Weirdness.... (https://www.excelbanter.com/excel-programming/301598-vba-ide-weirdness.html)

Trip[_2_]

VBA IDE Weirdness....
 
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




Papou

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






Tom Ogilvy

VBA IDE Weirdness....
 
You might have two buttons, one on top of the other. This can happen by
doing a ctrl+Click on the button with a slight movement of the mouse.
Perhaps you were trying to snap the control to align with a cell or size it
maintaining the aspect ration and tried holding down the Ctrl key, then
moved the mouse slightly (creating a copy ), then lined it back up over the
original without realizing you had made a copy.

--
Regards,
Tom Ogilvy

"Trip" wrote in message
...
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






Jon Peltier[_7_]

VBA IDE Weirdness....
 
You can tell for sure. Select the user form, then check the entries in
the drop down box at the top of the properties window. All of the
objects are listed, and if you select it in this list, it will be
highlighted in the form (so you can see what it's hiding under.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Tom Ogilvy wrote:

You might have two buttons, one on top of the other. This can happen by
doing a ctrl+Click on the button with a slight movement of the mouse.
Perhaps you were trying to snap the control to align with a cell or size it
maintaining the aspect ration and tried holding down the Ctrl key, then
moved the mouse slightly (creating a copy ), then lined it back up over the
original without realizing you had made a copy.




All times are GMT +1. The time now is 07:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com