Inserting rows if a particular item is chosen from a list

[MarthaSue]

User will choose an item from a list, by doing so, excel will insert one or
more rows depending on the item chosen . . .each row would have to be able to
have formulas in it as well . . .

 

[Dave D-C]

So you have
o) a listbox Click event
o) a decision depending on which item
o) to insert row(s)
o) to copy formulae
Do you have any of these done?