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

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

--
Regards,
Tom Ogilvy

"GHopson" <[email protected]> wrote in message
news:[email protected]...
> 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
>