USERFORM CONTROL COPY: IS IT POSSIBLE?i

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top