Excel 2007 : Spin button

hi

im in the middle of a project and im basically trying to take it one stage at a time, because im new to the this "new fandangled, excel whatsit". at the moment im trying to make a spinner button provide me with the total amount of sales of a certain product, by just multiplying for example £3.51 by 2. ive being doing some googling and ive come across what seems to be a response by someone answering such a question, but the answer given assumes that a layman such as myself, could fill the blanks.


Question
I can set up a spin button with whole numbers but I need to do it to decimal points 0.1, 0.2 etc, can you help?
I have tried but it reverst to one every time.

Answer
The spinner control will only do whole numbers - I would suggest that you link this to a cell that isn't used in the formula, and probably set to invisible by using white text on white background(hiding behind the control would be a good place) and then having your formula take that cell divided by 10 as it's value - that way, the spinner will still give you the results you need.

Hi protonLeah,

thanks for the response and the attachment

I think its time i admitted that im punching above my weight here and that this is my first ever excel project. i may as well jst tell you what im attempting.

i need to record total offers (sales) made by an individual worker, so that they can keep a running total themselves so they can have control on hitting their targets. As each product has a value and as each worker has to hit targets, i also need the total offers to produce, both average £per call and percentage of offers made against calls taken. what i need most importantly, is for the individual user to have the least amount of imput needed to produce these figures. hopefully my what ive "just about" managed so far should help you see how out of my depth i think i am, but also what im looking for. p.s you have probably sussed this already, but im litterally teaching my self as i go.. with a little help from you guys of course

think im getting the hang of this now. i hope its just because im nearly falling asleep now while doing this, but i really cant figure out how to work out the formula for percentage of offers made.

Hi

ok, so as you can see, i quickly realised that the tasked that i had built up to being the noah's II, wasnt that difficult in the end. the only remaining problem im stuggling with, is creating a way to £0.00 sales offer when the customer declines the offer made. the reason for this is because, we are still targetted on the offers made, irrespective of whether the customer accepts or not. we have to hit a certain £call, so if all the offers we make, have a financial value attached to them, this creates an incorrect reflection of the £call. The idea i have is to create a VBA button to press, when the offer that was made, was declined, in order to Zero the value but still keep the usage figure. Any suggestion?