Hi guys
i need help with something thats hopefully simple but I’m not very good
With reference to the attachment if the type (in cell E3) is New then i need a marco to produce a word art in the box with the words “Error”
If the type in cell E3 is Old then no error messageBook2.xlsx
Is this easy enough to do?
thanks
Hi a2424,
Try this event macro* on Sheet1:
HTH
Please Login or Register to view this content.
Robert
* To install this macro follow these four steps:
1. Copy my code to the clipboard (Ctrl + C)
2. Right-click on Sheet1 and from the short-cut menu select View Code
3. Paste (Ctrl + V) the contents of the clipboard from step 1
4. From the File menu select Close and Return to Microsoft Excel
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
perfect thats excellent thank you
You're welcome
If you could mark the thread as solved it would be appreciated.
Regards,
Robert
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks