XY coordinates to cell address? is it possible
 

Hi.

I need to select the cell beneath a button. Who can i do this?
I though about XY coordinates of the button...is this possible?

thanks SpeeD

XY coordinates to cell address? is it possible
 

an ActiveX button

MsgBox CommandButton1.BottomRightCell.Address

"SpeeD" wrote:

Hi.

I need to select the cell beneath a button. Who can i do this?
I though about XY coordinates of the button...is this possible?

thanks SpeeD

XY coordinates to cell address? is it possible
 

Patrick.

Just saved my day! thanks!!

SpeeD

"Patrick Molloy" wrote:

an ActiveX button

MsgBox CommandButton1.BottomRightCell.Address

"SpeeD" wrote:

Hi.

I need to select the cell beneath a button. Who can i do this?
I though about XY coordinates of the button...is this possible?

thanks SpeeD