View Single Post
  #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