Macro to change the value of a cell based on another cell value

[rbowie1980]

Hi all, I'm new the forum and looking for some help please.

Up until now i have managed to get by with google searches but my latest problem i just cant seem to find a resolve.

I have a worksheet that i use to track progress of activities based on a tick "a", I currently have a code set up so that when i double click the 100% cell an "a" is inserted in the cell and i have a simple formula =IF(AA6="a","a","") to populate the 90% then 80% etc to save double clicking each increment, the reason for the double click is i update the progress on a large touch screen TV.

Capture.JPG

the problem now is i have thousands of cells with the formula above and it takes a long time to calculate.

what i would like to achieve is when any percentage is double clicked the percentages up to that auto populates with an "a".

any help would be greatly appreciated.

[Mumps1]

It sounds like you are currently using a Worksheet_BeforeDoubleClick macro to insert the "a". Replace your current macro in the worksheet code module with the one below. You will not need any formulas.

Please Login or Register  to view this content.

[rbowie1980]

Thank you very much, works great. not wrapped my head round why though

can i push my luck and ask would it it be possible to remove the "a" using the double click in the event an activity was progressed wrongly?

[Mumps1]

Replace the current macro with these two. Double click to add the "a" and simply delete the "a" furthest to the right to clear all the a's in that row.

Please Login or Register  to view this content.

[rbowie1980]

That will do nicely, Thanks again

[Mumps1]

You are very welcome. Actually, you can use the double click both to populate the range with "a" and to delete them when you double click again. Replace the previous two macros with this one:

Please Login or Register  to view this content.