Excel: CONTROLs management programmatically

S

sharon

I'm trying to create a sort-of INVOICE spreadsheet, excel 2003, vba.

The way I'm doing involves adding new controls (for each new INVOICE line).

I have a userform where I created (only) first line controls, which I need
to increase to many (several) lines.
Some questions come to me:
1- Is it a way to copy each control (rather than just adding ) and just
change .Top property ...

2- As for dealing with INVOICE lines, must I change to other global design,
for example working with a recordset control?

TIA,
 
Top