Macro runs when i click on specific cell

**Macdave_19** · 08-19-2009, 04:50 AM

Hi all,

how would i make a macro run when i click on a specific cell?

hope someone can help

many thanks in advance

**Atila Akal** · 08-19-2009, 04:59 AM

You can do from worksheet selection change event

Please Login or Register  to view this content.

**DonkeyOte** · 08-19-2009, 05:20 AM

Alternatively...

Please Login or Register  to view this content.

**Macdave_19** · 08-19-2009, 05:22 AM

thanks both to be fair this is exactly what i had yesterday:

Please Login or Register  to view this content.

but for some reason it just wasn't working, now it's fine!!???

**DonkeyOte** · 08-19-2009, 05:28 AM

You may find you could revert to something along the lines of:

Please Login or Register  to view this content.

Re: Macro runs when i click on specific cell