INSERT NEW ROW MACRO BUTTON
Hi,
I am looking for a standard "insert new row" macro function that would be triggered by a simple "button" click from the user. I searched the forum, but only found specific macros (insert based on a value, insert every other lines...etc..). I am creating an excel "Use Case" template for several business units. All I want from these users, is to use my excel template to describe their daily tasks (step by step). So the first row will be for them to entire the title of their use case, the second row, their name, the 3rd row the overall description AND...finally, by default, one row with the Title SETP#1, with room for them to enter description on their step. Their would be a small button on the page that, when clicked, would add another row automatically STEP#2 so they go on and enter as many steps as they want. Thanks in advance for any recommendations on a macro to do this. Cheers, Guillaume |
INSERT NEW ROW MACRO BUTTON
I'm not quite sure what you're doing, but you may want to look at David
McRitchie's code: http://www.mvps.org/dmcritchie/excel/insrtrow.htm look for: InsertRowsAndFillFormulas If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm guillaumet wrote: Hi, I am looking for a standard "insert new row" macro function that would be triggered by a simple "button" click from the user. I searched the forum, but only found specific macros (insert based on a value, insert every other lines...etc..). I am creating an excel "Use Case" template for several business units. All I want from these users, is to use my excel template to describe their daily tasks (step by step). So the first row will be for them to entire the title of their use case, the second row, their name, the 3rd row the overall description AND...finally, by default, one row with the Title SETP#1, with room for them to enter description on their step. Their would be a small button on the page that, when clicked, would add another row automatically STEP#2 so they go on and enter as many steps as they want. Thanks in advance for any recommendations on a macro to do this. Cheers, Guillaume -- Dave Peterson |
All times are GMT +1. The time now is 11:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com