I have a UserForm that the Sales people will be using to calculate the cost
of a product. The UserForm has many Controls such as CheckBoxes, ComboBoxes,
TextBoxes, Option Buttons, etc. for the Sales person to navigate through.
When the sales person is done entering a products description there is a
Command Button on the UserForm that they will Click to add the product
description, product quantity,cost and an Edit Button onto Sheets1. I want
the sales person to be able to click the Edit Button and all the info. they
entered for that item will automatically be loaded into the UserForm for
editing. At any time there could be 5-6 items on Sheets1. How could this be
done?