Relative positions from a button
Option Explicit
sub testme()
dim myBTN as button
set myBtn = activesheet.buttons(application.caller)
mybtn.topleftcell.offset(0,3).value = "hi there"
end sub
You can assign this kind of code to all the buttons (from the Forms toolbar).
Steve wrote:
Hi,
I have a button (currently a form button but could be changed) on a sheet
that adds 1 to a value elsewhere on the sheet. This setup is replaicted for
other rows.
the macro currently increments the value by using the offset method relative
to A1.
I would like to know if there is a way to do increment the value using the
relative position to the button either by assigning the button to a cell or
another way?
Thanks
--
Dave Peterson
|