Hi im after a simple bit of code so that when i enter the number 6111 in a certain colunm, say colunm A:A that the cell that 6111 is entered will automaticly show a comment box saying "Attention"
Shouldnt be hard for you guys?
Cheers
Sane
Hi im after a simple bit of code so that when i enter the number 6111 in a certain colunm, say colunm A:A that the cell that 6111 is entered will automaticly show a comment box saying "Attention"
Shouldnt be hard for you guys?
Cheers
Sane
use this in the code page of the desired sheet
Please Login or Register to view this content.
Regards,
Khaled Elshaer
www.BIMcentre.com
Remember To Do the Following....
- Thank those who have helped you by clicking the Star below their post.
- Mark your post SOLVED if it has been answered satisfactorily:
- Select Thread Tools (on top of your 1st post)
- Select Mark this thread as Solved
Worksheet event code is stored on a worksheet module. To add it to your worksheet, do the following:
Copy the code
Select the worksheet in which you the code to run
Right click on the sheet tab and choose View Code, to open the Visual Basic Editor.
Where the cursor is flashing, choose Edit | Paste
Here is the code.
Please Login or Register to view this content.
use this instead of my previous code
Please Login or Register to view this content.
Last edited by Kelshaer; 03-07-2012 at 10:27 AM.
DaveExcel: Thanks, I just missed it
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks