Help with Excel and VBA related stuff

Hi there,

I'm pretty new at vba and so i need some help on this project i'm workin on. I have a working spreadsheet that gets data from an external source. Its live data and so is refreshed periodically. What I need to do is create a userform which lets me add rows into the spreadsheet.

Here are few problems and doubts that I have. Firstly, I have tons of columns considering this is a finance based spreadsheet. But my userform has only 1 combo box, a textbox, 2 radio buttons and an ok and cancel button. What i require is that when I fill in the details in these fields, and click ok, a new row needs to be created with only fields that have been entered. But what I also need is formulas and all that are present in previous rows to apply to the new row as well. I'm not too sure on how to even go about it.

I could loop through a column to get the items for the combo box, but how do i get rid of duplicate items?

My main concern is inserting and making sure that the formulas in above rows get extended to the new row. Hope this is somewhat clear and would appreciate if anyone could help.

Thanks!!

VBA is documented in the Excel online help, among other places. www.mvps.org is a good site to look for code samples.