New Line Items at Runtime
 

I am wanting to create an Order entry Form in Excel using a combination
of User Forms and WorkSheets. I need to add line Items (at runtime)
but the number of lines is unknown. Is there a way to add textboxes as
the end user needs them?

Thanks,
Gary

New Line Items at Runtime
 

I assume you mean on a userform. Look in Excel help at the Controls.Add
method.

--
Regards,
Tom Ogilvy

"GHopson" wrote in message
ups.com...
I am wanting to create an Order entry Form in Excel using a combination
of User Forms and WorkSheets. I need to add line Items (at runtime)
but the number of lines is unknown. Is there a way to add textboxes as
the end user needs them?

Thanks,
Gary