Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
summing line items by category The Ambassador Excel Discussion (Misc queries) 2 January 4th 10 05:22 PM
line up items in column a with items in columns b, c, etc meera123 Excel Discussion (Misc queries) 0 September 2nd 08 02:20 PM
Is there a way to sort a list of multi-line items? R Scott Lowden Excel Worksheet Functions 3 July 10th 07 04:54 AM
Three items, column and line chart Carole O Charts and Charting in Excel 2 April 11th 05 03:06 PM
SUMING VARIOUS LINE ITEMS FROM MULTILPLE WORKBOOKS rfhorn Excel Worksheet Functions 2 April 6th 05 12:47 PM


All times are GMT +1. The time now is 09:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"