Hi everyone,
I need a piece of code that can be added to a macro I have written for a "save button" which when pressed checks the contents of cell C15 on sheet 1 of my workbook against all values in column A on sheet 7 for a duplicate and if it finds one shows a pop-up box asking the user to enter a different value to avoid having multiple items with the same reference number.
Thanks in advance,
Glen
Last edited by Glensafro; 03-12-2012 at 12:31 PM.
Glen,
Give this a try:
Please Login or Register to view this content.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
That's great thanks Tiger. Just a note incase anyone else reads this, the actual code I used was the one below. I had to tweek the cell references slightly because my sheets aren't actually called sheet 1 and sheet 7, but that is their reference in the VBA window.
Thanks again!Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks