Easy one

**newestnewbie** · 09-26-2006, 05:36 AM

Hi,

This is my first time here and my first time trying to program in Excel.

I have a workbook called myworkbook and within this I have 3 sheets called good, better and best.

I have 2 questions:
1.) How do I sum all the values in a column and then display the answer in another column of sheet GOOD. Lets say the values are from b1 - b20 and the total must appear in b22. This must be done when the user clicks a button on the sheet - ie onclick.

2.) In my sheet called BETTER, I have a value which will always be in b22. This value will ALWAYS be less than the value in sheet GOOD, postion b22. In sheet BETTER, I now want a button that when clicked will go into a loop which adds 0.01 to the value in sheet BETTER, postion b22 until this value (in BETTER, b22) is equals to the value in GOOD, postion b22. It only has to be accurate to the closest whole number (dont worry about decimals).

I other words - all I'm trying to do is add 0.01 to a value in one sheet until it is equal to the value in another sheet.

Hope you can help.

Thanks,
NNB

**funkymonkUK** · 09-26-2006, 06:08 AM

refer to example attachment

**Simon Lloyd** · 09-26-2006, 06:10 AM

This does what you want all you have to do is create the buttons! however it doesnt count the amount of 0.1's that are added!

regards,
Simon

Please Login or Register  to view this content.

**Simon Lloyd** · 09-26-2006, 06:13 AM

>>>>>>>>>>>>>>>Pays Homage to Funkymonk a true god!<<<<<<<<<<<<

I know when ive been beaten!

Regards,
Simon

**funkymonkUK** · 09-26-2006, 06:14 AM

Sorry for stepping on your toes Simon but I think I bet you to it.

Just some advice you should add .value when you are refer to values for a particular cell oh and they way you did it allows the user to see what the formula is but you can use this function application.worksheetfunction.sum (range) check my example.

**funkymonkUK** · 09-26-2006, 06:15 AM

Originally Posted by Simon Lloyd

>>>>>>>>>>>>>>>Pays Homage to Funkymonk a true god!<<<<<<<<<<<<

I know when ive been beaten!

Regards,
Simon

hehehe but you beaten me by the amount of posts you have submitted.

**Simon Lloyd** · 09-26-2006, 06:17 AM

I did say i wasn't an expert.........see limited knowledge gets you knowledge..thanks for the pointer and i did check your example.........Very smart!

Thanks again oh great one!

Regards,
Simon

**newestnewbie** · 09-27-2006, 03:06 AM

Hi all,

Just want to say thanks for the help. It works perfectly and this little app has saved us a WHOLE LOT of time!!!

Thank you very-very much.
NNB