Can a macro be assigned to a button that can identify what...?

[Mitsu]

Can a macro be assigned to a button that can identify what cell the clicked button is in ? In other words, If I had a button in a non-selected cell and then clicked on the button, I want the button's macro to identify the cell it is in.

Any ideas?


Thanks in advance,
Mitsu

 

[vb6novice]

Mitsu,

Please explain how it is that a button is "in" a cell. When you create buttons on a spreadhseet they are on top of the cell or cells, depending on the button position and size. The value of a cell that happens to be under the button is coincidental to the fact that the button is above it.

Depending on what you wish to accomplish, you might be able to use the properties of the button to give you some other information.

 

[Mitsu]

Yes, I guess it is "over" the cell.

Mitsu

 

[jackha18]

may be looping through range.top and range.left properties of each cell within some reasonable range (e.g. 500 by 500 cells) you could find the cell whos top and left properties are closest to your button's top and left.

 

[plopez]

Hi, I need some help for to put an image in a commandbutton with code in VBA excel.
What kind of image it should be? an .ico or a bmp
Thanks 4 your help.

:=)