Okay have run into a couple of issues here. Sheet selection method is not working. To get there, enable macros/ click on deliveries and view the form with a multicombo & text data entry. This is what I'm trying to enter via the form.

The code fails on the very first sheet selection effort. What I was hoping for is that I can use the value of the cboLocation choice as the method of selecting the correct sheet and then using code very similar to that which was suggested in the other thread "writing data to subsections on the same page".

Seems I've bitten off more than I can chew, but being a fearless potential athlete, I stepped out into the darkness. Can someone please turn the light on??

Ted