UserForm (QTY) TextBox, Increment by batch (QTY) and add to Cells on Sheet

Hi,

I have a (Batch QTY) TextBox on a userform, When i click the add button i need to increment the QTY onto my excel sheet called "Dump" to cell "B2" (B1 is the header)
The QTY needs to start at 12 and with a prefix of "OS" (OS012 up to OS256), As you can see the code needs to change the prefix from "OS0" for 2 digit number and "OS" for 3 digit number inputs from the TextBox

e.g. if have a (Batch QTY) of 100 in the TextBox when the add button is clicked, i need to send:
"OS012 to cell "B2", "OS013 to cell "B3" down to "OS121" to cell "B101"



This is what i have so far.

HTML Code: 

TIA

Hi TMS,

I dont think i made my self very clear. I need to add 1 batch of numbers in each Workbook.
lets say the batch Qty is "10", I type the batch QTY of 10 and click add i need to add the prefix and add them to my sheet called "Dump". (OS012 cell B2, OS013 cell B3, OS014 cell B4, OS015 cell B5, OS016 cell B6, OS017 cell B7, OS018 cell B8, OS019 cell B9, OS020 cell B10, OS021 cell B11)

When the sheet is reset the next batch could be 150, again Must start at OS012 and will end with OS162 (12 + Batch number)

Prefix (must always start at 12, e.g. OS012 + Batch QTY

Hi TMS,

I have tested the code. it is doing as you say, but i only need to add the QTY i am inputting in to the TextBox (e.g. if i enter 10 as a QTY i only want 10 outputted to the sheet), if i have more it messes up all my data on other sheets (as it now thinks i have added over 130 in one batch)

if i enter 10, i want 10 on the sheet. If i enter 20 i want 20 on the sheet.

TIA