Buttom linked to a cell in excel

[BoFenger]

Hi
Is it possible to make a button in excel (fx. a textbox) that links to a macro (that¡¦s easy), but where the button is linked to a cell so VBA knows the position of the button. Right now I have a sub for every single button, quite annoying ƒº

\Bo

 

[SkipVought]

Hi,

Each object on a sheet has a TopLeftCell and BottomRightCell property that identifies the corresponding sheet cell.



Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[BoFenger]

Hi
If I assign two different object to the same macro, how do the macro know which object I have pressed

\Bo

 

[SkipVought]

Simple...

sub button1_click()
  MyMacro button1.topleftcell
end sub
sub button2_click()
  MyMacro button2.topleftcell
end sub

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com