I need the code to use for a VBA textbox in excel.
1. I want to scan a UPC code into a textbox then write the data to cell "a5"
2. next enter a qty on hand into another text box and write this data to cell "b5"
3. next repeat step 1- except write the UPC to the next available cell in column "A"
4. next repeat step 2- except write the UPC to the next available cell in column "B"
then repeat all steps and continue entering data in the empty cells
example of what I have done already
Thanks in advance for any help anyone can give me...I would really appreciate it.