Change Yes/No value by clicking on cell

[fusion007]

Hi...I need some help with a code please for when a user clicks on a cell the value in that cell changes to a "yes" and if they click in that cell again it changes to a"no". This should be a loop.

I will have a few cells like this in the worksheet. So will use the code at each I need to work this way.

These cells will be used for calculations elsewhere in the workbook.

I'd be very grateful for some help on this please. Thanks

[Mordred]

Hi Fusion007, I don't know if this fulfills your requirements but I got this code:

Please Login or Register  to view this content.

to work but you would have to double click the cell and then click out of it for it to run the Worksheet_Change event.

[Whizbang]

Enter this into your worksheet module:

Please Login or Register  to view this content.

Of course you would need to adapt it for the ranges you want to specify.

I believe, however, that the chance of a user accidentally selecting or clicking on the cell and changing its value is rather high. I would recommend using the BeforeDoubleClick event, rather than the SelectionChange event.

Please Login or Register  to view this content.

[fusion007]

Hi Whizbang...nothing happens when I double click in Cell A1. I like your idea about the user accidently clicking on the cell and hence changing the value.

Hi Mordred...It works but I would like to specify each individual cell where I want this yes/no to operate and ideally it to work without the user having to move off the cell

[Mordred]

Hey fusion, I would say to try whizbang's again but be sure to capitalize your first letters.

[Mordred]

From Whizbang's code, slightly modified to accept a lower case yes:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[snb]

Please Login or Register  to view this content.

[Mordred]

You make it look so easy snb!

[snb]

I'm so sorry, I didn't want to offend you ...

[fusion007]

Thank you all for taking the time to reply. snb I've used your code as I can easily define the ranges.
Thanks again.