Hi,

I am in need of some help with this macro.

Im using the Worksheet_BeforeDoubleClick macro which allows me to insert a
row and fill formulas by a simple double click.

I want to use this macro for the following purpose.

What i want to be able to do is, when i select an item in a list box on my
sheet, i want a new row to be added underneath the listbox as soon as i
select the item in the listbox. Of course this new row will have had the
formulas preserved in it from the row above.

Could anybody help?

Thanks