Enter a number into a cell that does a sum in background and returns the value

[djgaryc]

Dear All

I have been searching the web to help me with my latest excel issue, and I think it comes back to having to use VBA to solve it. It is a basic cash checker worksheet that i need to work out cash values.

I want to enter a value into B2 (for example 3) that will return the answer of B2*B3 (3*£50) and put it in cell B2. (£150) I hope i have been clear enough to make sense.

I have uploaded the worksheet becuase i have no clue about VBA's, how to work them out or even where to put them, I was hoping someone has the knowledge to help me?


Thanks for helping
Gary

[LeoTaxi]

Please Login or Register  to view this content.

Kind regards
Leo

[alansidman]

an alternative:

Put a command button on your sheet and attach this code to the button

Please Login or Register  to view this content.

[djgaryc]

Please Login or Register  to view this content.

Kind regards
Leo

Many thanks for your help Leo.

The worksheet doesn't do what i need it to do

[djgaryc]

an alternative:

Put a command button on your sheet and attach this code to the button

Please Login or Register  to view this content.

Thanks for the help alansidman

I tried adding it as a button, but it didn't do what i need it to. I must have explained myself worng I have uploaded 2 screen shots to what I'm trying to explain

Type a nember in a cell, click onto another cell and the macro change that number by multiplying it by the cash vaulue it represents... for example in the help pictures it changes 3 in 3*£50=£150

Regards
Gary

[LeoTaxi]

Please Login or Register  to view this content.

Kind regards
Leo

[djgaryc]

Please Login or Register  to view this content.

Kind regards
Leo

Perfect!!! - Genius, Many thanks

Gary