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 |
All times are GMT +1. The time now is 10:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com