Hi - I'm devising an order processing system, so far user selects data on Quote form, generates quote which also generates Order button. If customer confirms order user clicks on Order button which generates confirmation pdf and draft email, all good. As part of this process I'd like an OrderProcessing workbook to be updated with a specific set of checkboxes and date picker cells to enable progress tracking of each order. The attached spreadsheet contains a basic example of what's required. I've tried a few bits of vba code which I can get to create check boxes but I need full control over each one. If the user clicks on place order it should be possible to open the OrderProcessing sheet and add values to each cell per row for that order. Where the cell in the attached says Auto fill this will be taken from the Order sheet for Order Ref, Component type and Description. All other check box and date picker cells will be the same. What will happen continuously after that is the user will update each check box to signify progress of the order over time. If anyone can explain how to just create a bunch of dynamic check boxes and date pickers with variable names and captions I should be able to deal with the autofill values. Hope I'm making sense - please shout if not. Thanks
Bookmarks