Hi, I am trying to run a macro when I enter specific text into a specific cell. as you will see I am a complete novice at this, any help would be gratefully received.
This is what I have tried, amongst other things, without any success.
Best Regards
Please Login or Register to view this content.
DeeK
Last edited by deek; 08-02-2014 at 10:09 AM. Reason: Added Code tags
Hi, deek,
you would need to wrap your procedure with code-tags acording to Forum Rule #3 in order to get suggestions to your issue.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Hi, deek,
the event you presented in the opening post is for moving the mouse and activating different cells in a sheet. If the event is to enter or edit a cell the Worksheet_Change-event is the one to use.
Ciao,Please Login or Register to view this content.
Holger
Apologies, I see how easy it is to read now
Originally Posted by deek
Hi, I am trying to run a macro when I enter specific text into a specific cell. as you will see I am a complete novice at this, any help would be gratefully received.
This is what I have tried, amongst other things, without any success.
Best RegardsPlease Login or Register to view this content.
DeeK
Hi Ciao Holger,
I have copied your suggestion into the VBA sheet, having opened it by right clicking on the tab, and viewing the code. but when I type BLAH in to F7, the macro "Macro1" doesn't run, I have also tried with the code in the module, with no effect.
do you have any suggestions please.
DeeK
Hi, deek,
maybe have a look at the workbook attached and test the code in there (it works for me with Win7 and Excel2007).
Ciao,
Holger
Ciao,
Many thanks, this worked.
Regards
DeeK
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks