Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
rkg
 
Posts: n/a
Default Create a tabular control


Hello-

I am a novice to Excel forms. I have to create a form template in Excel
to enable the user to enter Purchase Order information for multiple POs
in a single form. I want to create a single structure for PO and then
Now, the header level information of PO can be collected in simple text
boxes but I want to create a tabular control for each PO so that item
level information can be caught into a scrolling control and lines may
be added to it as needed.

I want to create a structure for line items within a PO structure and
then replicate the whole compounded structure once the user clicks "add
PO" button.

PO Number
Date
Purchasing Dept

Item # Item Description Item Qty
Item1 Desc1 Qty1
Item2 Desc2 Qty2



I have looked up the controls available in the Control Toolbox but I
cant find a table control. Would appreciate pointers to the
accomplishing the above.

Thanks!


--
rkg
------------------------------------------------------------------------
rkg's Profile: http://www.excelforum.com/member.php...o&userid=22818
View this thread: http://www.excelforum.com/showthread...hreadid=394018

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
How to insert date using a pop up calendar control in a cell i Iain the scout Excel Discussion (Misc queries) 4 December 17th 05 08:10 PM
Vanishing Control Toolbox Command Buttons Fritz24 Excel Discussion (Misc queries) 2 June 7th 05 01:39 PM
How do I create a pointer chart, like a speedometer? Ricardo Kozlowski Charts and Charting in Excel 2 March 31st 05 03:23 AM
Copying list-box control Excel Discussion (Misc queries) 1 January 6th 05 01:39 AM
How do I create a button or control that will automatically go to Roger Excel Worksheet Functions 1 October 29th 04 01:31 AM


All times are GMT +1. The time now is 05:07 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"