Adding button dynamically

  • Thread starter Thread starter lagodch
  • Start date Start date
L

lagodch

Here is what I am trying to do...
I have a button on a worksheet that onclick, takes data from that
worksheet and adds it into a dynamically created row on another
worksheet. What I want to do along with this is dynamically add a
"Delete" button at the end of this generated row so that the user may
delete the entire row, data and all, if they want.

Since this is dynamic, I don't have exact placement for the button,
just the last cell on the row that was created. Any help would be
greatly appreciated!!!
 
Cells have a Left and Top property that will give you its location in the
worksheet, as if it were a control on a form.

Try
?"Top: "; Range("B2").Top;", Left: ";: ?Range("B2").Left
in the Immediate Window, for example.
 
Back
Top