Database entries as rows and columns

Hi rfiehn and welcome to the forum (looks like your second post).

Excel has this tool/function/dialog that is not on the ribbon any more. It is called the Form Tool. It will do exactly what you are trying to do with your userform. See if it is what you really want without all the programming or VBA headaches.

http://www.addintools.com/documents/...data-form.html

If you have too many fields then you can add
http://spreadsheetpage.com/index.php/dataform/home

Hi,

If you have all five blocks of Showroom/Model Number / Description completed are you expecting to see 5 rows on the Record sheet?

Assuming that's the case then there's a much simpler way of updating a database from a data entry form. The technique I always use is to use some hidden helper rows above the data entry form to replicate the Record sheet field headings. The helper cells are linked directly to the relevant data entry cell. Usually of course only a single row is required, much as you have now. If you name the helper row (say NewRecord) then a simple macro like

Please Login or Register  to view this content.

i.e. this reduces your current 30+ line macro which contains time consuming loops to just the two lines above. All you need to do is instead of a single helper row create 5 hidden helper rows named NewRecord with each of the 30 cells linked to the Data form cell.