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