Help With Excel Form Outputting Weird Values

**TeachPower** · 08-07-2011, 11:51 AM

Hello all. Nice forum.

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]Please Login or Register to view this content.[/CODE]

-Regards
TeachPower

**Simon Lloyd** · 08-07-2011, 01:47 PM

It would be clearer to us if you could provide a sample workbook with the entire code in it alnong with some sample data.

**royUK** · 08-07-2011, 01:57 PM

The problem is probably that your cell is not formatted as a date, but a number

**TeachPower** · 08-07-2011, 02:54 PM

Here is a sample workbook of my entire project. What I need is the following:
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.

**TeachPower** · 08-08-2011, 09:15 AM

Hello? I uploaded a sample sheet from my project as you asked. Is there anybody that can please help?

**Simon Lloyd** · 08-12-2011, 12:43 PM

Firstly revisit your userform and get the references right, for starters you have this Private Sub cmdClear_Click() as your clear button sub but it's actually Private Sub cmdClearForm_Click(), you also want to run your queries on Sheet1 but it doesn't exist.

Go through it with a fine toothed comb and then post back when all the references...are correct.