Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamically Adding Textbox To Frame | Excel Worksheet Functions | |||
Adding values in first "X" number of rows dynamically | Excel Worksheet Functions | |||
Issue with the Camera Button for creating dynamically updating pic | Excel Discussion (Misc queries) | |||
Dynamically Adding Code to Buttons on an existing UserForm | Excel Programming | |||
Adding a webBrowser object dynamically to a sheet | Excel Programming |