bottomrightcell

[Mike Goodrich]

I want to write a macro that will place a "1" in the bottom rightcell of
an object when I click the object. All I can find is a way of detecting
the bottomrightcell of a chart but not an object.

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software! Free Support at
http://www.ozgrid.com/forum/ **

 

[Dick Kusleika]

Mike

You can make a sub like this and assign it to that Forms object

Sub OneBottom()

ActiveSheet.Shapes(Application.Caller).BottomRightCell.Value = 1

End Sub