How to loop over SendKeys method

[ImranBhatti]

Hello

In the attached workbook and with the selection if I Press "F2" Key and then "Enter" key repeatedly the all cells are activated one by one and refreshed.During this process I was recording a macro.But I could not get an automated code for that.
What I want is to select the CurrentRegion and keep pressing F2 and Enter ,,F2 and Enter So that that the Randbetween formula generate different digits and conditional formating is applied and as a result it should look like flashing game.
Then I also want to stop it
Thoughts?


Best Regards
Imran Bhatti

[cytop]

If you're using RandBetween in the cells, why not just recalculate the sheet or the range...?

[ImranBhatti]

Hello sir cytop

Thanks that did the trick but how can I do it repeatedly?
I mean I want to click only once and the flashing should continue until I stop it with anther action say clicking in any cell.
I used this

Please Login or Register  to view this content.

[cytop]

Declare a public Boolean variable in a module and make sure your procedure is in that module
Add a button or shape to the worksheet and assign/call the procedure in the click event.
Change the procedure

Please Login or Register  to view this content.

Click the button/shape to start and stop.

The DoEvents is critical. You will not be able to do anything with Excel, including stopping the code, if you do not include it

[ImranBhatti]

Perfect.It is stopping the loop by double clicking in a cell