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

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