DoubleClick not responding immediately

I have a doubleclick macro that works nicely on one sheet, but with a slight change, is not working well on another sheet.
The code that isn't working well is below:

Please Login or Register  to view this content.

The code on another sheet that works well has one small difference.
Instead of .Cells I have .EntireRow.

The code on the first sheet will change the font in the active cell from black to magenta or the reverse, however I must doubleclick _twice before it takes effects.

I only need to doubleclick once on the other sheet with the .EntireRow code.

Is there something I can change to make the code work right away for the first sheet?

TIA

Moved from Excel General

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Hi,

I assume that's a typo where you say you only want to 'double click' once (sic), and that you just mean you want to click once.
In which case use the Selection Change event rather than the double click event and remove the 'Cancel' instruction. i.e.

Please Login or Register  to view this content.

Default font colorindex will be xlcolorindexautomatic I think so font will change from Automatic (this is usually black) to black then change each time after this. You must test for this also in first test.

Please Login or Register  to view this content.

I do not know why this works in other sheet - perhaps you have already set font colour?

This is different in 2003 from 2007 and later version, where default will be 1 - I do assume that 2002 is same as 2003. Also you must know that if entire row does not have same font colour, you will have error because colorindex will return Null in all versions.

Originally Posted by ChrisXcel

No actually, it wasn't a typo.
I thought about it as possibly being misinterpreted that way however.
The macros are designed to activate as double click events.

In that case use the double click event for both the Entire row version and the .cells version. I don't experience the apparent problem you mentioned in your first post so if it's still occurring upload your workbook. so that we can check.

I conducted a series of experiments to try to get to the bottom of this.

Worksheet 1 was the worksheet that was 'working'
Worksheet 3 was the worksheet that wasn't working.

In Worksheet 3 I double-clicked (dc'ed) on a fresh cell that was black. Nothing happened.
I dc'ed again and it turned magenta.
I dc'ed again and it turned black.
I dc'ed once again and it turned magenta.
I dc'ed again and it turned black.

On each fresh cell this pattern repeated.

Then I went back to a cell I had clicked on before which was now black.

It turned magenta on the first dc, so it remembered its last state.

Then I copied the code from Worksheet 1 into Worksheet 3 (first editing out 'cell' dc code) so now the worksheet had 'EntireRow' code.
I got the exact same response as above.

So I went back to Worksheet 1 and tested out the code carefully there and sure enough,
it was working the same way here too!
The reason why I thought it was working properly in Worksheet1 was because there are a series of rows that I work with over and over, changing the color back and forth. I don't go to fresh rows that often.

So Izandol was spot on!

When a fresh cell/row is dc'ed it first turns to black (even if it was black) , then it will turn to magenta on the next dc.

So now I would like to know how to avoid this?
Is it possible to enter code that will allow a fresh cell/row to change font color (from black to another color) on the first dc?

Hi,

In terms of the code it is reacting to whatever is in the cell being clicked and treating all the cells in the row the same.
Are you saying that if some cells are black and others magenta you want to toggle each of them to the other colour?

If all cells are not same it will be better to test only Target cell, change entire row and then change green/red cell back to its original colour.

OK, thanks Izandol.

I think I know how to get this working now.
I will play around with it some more and see what I can come up with.

Originally Posted by ChrisXcel

If it is automatic, it changes the colour to black and then to magenta.

Why do you do two steps?