Posted 07 August 2011 - 06:48 PM
I have been having some trouble with this form in an Excel sheet I created to keep track of my eBay transactions. Every time I input data into this form [code is below] it works up until PayPal International Sales (variable is txtPaypalIntern.Value). It puts all the data into its correct cell as its typed in. When it gets to the cell where the data I typed into the form for PaypalIntern is supposed to go, it always inputs 40,614. Every cell after that in the row contains the data in the wrong place. The CLEAR and CLOSE buttons in the form also don't work. I can't remember if I downloaded this code to make the form or created it myself as it was a year or so ago. Can someone look at the code below for the form and tell me what is going wrong?
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.
Education Resource Library for the classroom & boardroom