Hi all,
how would i make a macro run when i click on a specific cell?
hope someone can help
many thanks in advance
Hi all,
how would i make a macro run when i click on a specific cell?
hope someone can help
many thanks in advance
Last edited by Macdave_19; 08-19-2009 at 05:22 AM.
Mr MaGoo
Magoo.Inc MMVII
If i've helped please add to my Rep by Clicking on the Blue Scales in the top right hand corner of the post
You can do from worksheet selection change event
Please Login or Register to view this content.
Alternatively...
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
thanks both to be fair this is exactly what i had yesterday:
but for some reason it just wasn't working, now it's fine!!???Please Login or Register to view this content.
You may find you could revert to something along the lines of:
Please Login or Register to view this content.
Last edited by DonkeyOte; 08-19-2009 at 05:31 AM. Reason: edits - sorry!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks