title: How to add autofill to all the textboxes
body: <p>I am new to vba and I want to learn. Please help me with the following:</p>
  <p>I have this application(see the picture) which I use to enter data in a worksheet (it is more easy to use compared to completing manually). It is basically an inventory management system. When I add a product in there I can choose between sale or purchase.</p>
  <p><strong>The next thing I would like to implement is to autofill the form whenever I want to add a sale (considering it was added as a purchase in the first place), based on a serial code for example. This would be very useful because I wont have to complete all the text boxes again when I enter a sale in the database</strong></p>
  <p>Do you have any ideas about how I could do this?</p>
  <p>Kind regard,
  Traian.</p>
  <p><a href="https://i.stack.imgur.com/jpLyI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/jpLyI.png" alt="enter image description here" /></a></p>