With Worksheets("Data")
i = .cells(rows.count,1).End(xlup)(2).Row
.cells(i,1).Entirerow.Insert
.cells(i,1).Value = Userform1.Combobox1.Value
.cells(i,2).Resize(1,5).FillDown
End with
--
Regards,
Tom Ogilvy

"Abhay Sanan" wrote in message
...
I've created a userform which has a lot of stuff like combo boxes, option
boxes, text boxes. Since I'm relatively new to this I was wondering if I
could get any help on as to how to code for stuff like combo boxes. Is it
possible to add stuff into combo boxes that will automatically be inserted
into the excel spreadsheet. Where can I get some sample code for
reference?

Also, my each row on my spreadsheet has columns that do several
calculations
using data from other columns in the same row. So if I need to add a new
row
using the combo box, will it be possible for the formulas for the other
cells to be added as well in the new row?? Thanks in advance