R
rkg
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!
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!