How to make vba to wait until I select another cell

Hi, tamilvendhan,

for a continuous selection:

Please Login or Register  to view this content.

For multiple areas in the selection:

Please Login or Register  to view this content.

Or use the Worksheet_SelectionChange-event behind the worksheet to start the code.

Ciao,
Holger

Thanks for your fast reply.

But i think I have explained my need clearly.

Tasks I want to do is as follows

I want to check about 10 formulas stored in 10 adjacent cells
So first I want to select a cell and run the macro.
My code will colour the precedent cells, i will have a visual check
Then I will move to the adjacent cell using arrow keys
As soon as I moved to the adjacent cell, I want my code to execute automatically and colour the precedent cells
I will have a visual check
Then I will again move to the adjacent cell using arrow keys
so on
...
...
...

till I check all the cells with the formula

I cant use Worksheet_SelectionChange-event because I want this code to be stored in my default excel file and use in any excel I work.


Hope you get my need.

Hi, tamilvendhan,

Hope you get my need.

Could you be kind enough to explain to me what the Worksheet_SelectionChange-event does? AFAIK it will be triggered by any change of the cursor in the sheet it monitors and could meet your requirements. Maybe you should use a cell/control to switch the event from acting to any change to just pass the action.

I cant use Worksheet_SelectionChange-event because I want this code to be stored in my default excel file and use in any excel I work.

Then maybe use Class programming for that part. If you donīt want that event I could only think of a macro being applied to the change of the cursor arrows (which I wonīt use) or start it manually - I canīt see a normal way in Excel VBA to suit your needs.

Ciao,
Holger

Hi, tamilvendhan,

to start with maybe have a look at Classes In VBA or Custom Classes and Objects.

Ciao,
Holger