Hi everyone,
For the love of god I couldn't figure it out.
I have a document (all on one sheet) that has multiple sections. In each section there could be multiple rows "problems". I'm trying to add two buttons at the end of each row ("problem") to either ADD another row below where it's clicked (to add another "problem" directly below it) or DELETE the row where it's clicked (when "problem" is resolved). The top row ("problem") in each section will have only ADD button as there is nothing to delete. And each added row will have both buttons. I'll use "+" (add) or "x" (delete) as button names.
I tried copying an empty row with buttons from hidden row but I only can paste it under/above a certain row, so basically if I add problem, the whole list will be shifting down or up, I couldn't figure out how to add row underneath where "+" is clicked. I also tried double-click but it only work in relation to "active" cell, which won't be necessarily the case every time a row is added or deleted.
Finally, instead of ActiveX button (as their margins are too big) I decided to create a shape and assign macro to it.
Thanks so much for any suggestions! I think at this point my brain is totally fried trying to figure this out.
For the love of god I couldn't figure it out.
I have a document (all on one sheet) that has multiple sections. In each section there could be multiple rows "problems". I'm trying to add two buttons at the end of each row ("problem") to either ADD another row below where it's clicked (to add another "problem" directly below it) or DELETE the row where it's clicked (when "problem" is resolved). The top row ("problem") in each section will have only ADD button as there is nothing to delete. And each added row will have both buttons. I'll use "+" (add) or "x" (delete) as button names.
I tried copying an empty row with buttons from hidden row but I only can paste it under/above a certain row, so basically if I add problem, the whole list will be shifting down or up, I couldn't figure out how to add row underneath where "+" is clicked. I also tried double-click but it only work in relation to "active" cell, which won't be necessarily the case every time a row is added or deleted.
Finally, instead of ActiveX button (as their margins are too big) I decided to create a shape and assign macro to it.
Thanks so much for any suggestions! I think at this point my brain is totally fried trying to figure this out.