Adding button dynamically
 

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!!!



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Adding button dynamically
 

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.

--
Bob Kilmer


"lagodch" wrote in message
...
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!!!



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/