My big mouth got me in trouble again...

I told my bosses that I could make a series of UserForms act like a software application to help operators generate labels for parts. I've had no trouble gathering all the part information and generating a print out utilizing a pre-made template. However, I can't count on the idea of operators/work leaders having the know-how or time to make new templates when new parts come out.

I've experimented for the last 2 days with generating Form labels based on measurements gathered from the sheets of label paper and placing them on an over sized UserForm. I've also tried having the user input the measurements and generate the forms based off of column and row heights. Both of these attempts are not "clean" by any means.

Basically I'm looking for any suggestions on automatically generating 8 different types of label templates. Just looking for pointers in some kind of direction.