ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Buttons Adding lines (https://www.excelbanter.com/excel-programming/370001-buttons-adding-lines.html)

darkelf26

Buttons Adding lines
 
I have a form that people report errors on. at the end of each row I have
added a click button that adds a new row and formats it to the same format as
the row above. This all works fine.

However all buttons below this row now add a row at their old locations. I.e
if I have a clickbox at line 1,2,3,4 and use the button to add row between 1
and 2, buttons 2,3 and 4 no longer add a row under their new row locations. I
am looking for any help in scripting this so when the button moves down a row
its addline function also moves down a row

Tom Ogilvy

Buttons Adding lines
 
Most would use the TopLeftCell property or the BottomRightCell property to
determine where the button is located and where the row should be inserted.

--
Regards,
Tom Ogilvy



"darkelf26" wrote:

I have a form that people report errors on. at the end of each row I have
added a click button that adds a new row and formats it to the same format as
the row above. This all works fine.

However all buttons below this row now add a row at their old locations. I.e
if I have a clickbox at line 1,2,3,4 and use the button to add row between 1
and 2, buttons 2,3 and 4 no longer add a row under their new row locations. I
am looking for any help in scripting this so when the button moves down a row
its addline function also moves down a row



All times are GMT +1. The time now is 01:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com