Another question I have that I can't figure out is how to put into the form a way to calculate consignment splits. What I was thinking is putting a checkbox value into the form so I can check if it is a consignment item or not. IF the consignment checkbox is checked then to calculate "selling price X percentage" to figure my portion. How can I incorporate that into my form? Thank you for any help. So essentially I need help on the following things:
1) Have the form enter the data inputted into the correct cells.
2) Have the CLOSE and CLEAR buttons close and clear the form.
3) Input into the form a checkbox that when checked will calculate my percentage on the sale (selling price * percentage) in its own cell.
Can you please help me through this? Thank you for all your help.