Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to insert date using a pop up calendar control in a cell i | Excel Discussion (Misc queries) | |||
Vanishing Control Toolbox Command Buttons | Excel Discussion (Misc queries) | |||
How do I create a pointer chart, like a speedometer? | Charts and Charting in Excel | |||
Copying list-box control | Excel Discussion (Misc queries) | |||
How do I create a button or control that will automatically go to | Excel Worksheet Functions |