Double click toggle between Y / N

[CDandVinyl]

I'm trying to add to my double click code that if I double click F2 and that it is currently N , then it should be changed to read Y , and vice-versa.

Can someone advice with some VBA to satisfy this?

Grateful for any help.

[protonLeah]

Please Login or Register  to view this content.

[CDandVinyl]

Excellent - thanks.

BTW , if I were to run this on a merged cell (F2:F3) , how could the code be amended to accommodate this?

[Rick Rothstein]

This one-liner is an alternate to using the Select Case structure for your original question...

Please Login or Register  to view this content.

As for your extended question, we just need to force the one-liner to look as the first cell in the merge...

Please Login or Register  to view this content.

Note: I am assuming this one-liner is in your DoubleClick event procedure along with another line of code setting the Cancel argument to True.

[CDandVinyl]

OK thanks. This works too.

I took your suggestion to expand the code to this :

Please Login or Register  to view this content.

This accommodates the merged cells and solves the issue.