Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Help With Excel Form Outputting Weird Values


  • Please log in to reply
1 reply to this topic

#1 Teach Power

Teach Power

  • Members
  • 54 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:FL
  • Local time:11:22 PM

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.
-TeachPower
TeachPower.net founder
Education Resource Library for the classroom & boardroom

BC AdBot (Login to Remove)

 


#2 Geoffc

Geoffc

  • Members
  • 89 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Warragul, Australia
  • Local time:02:22 PM

Posted 12 August 2011 - 07:11 PM

Sorry, TeachPower, I can't find the form. Did a reference get dropped?

geoffc




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users