Hi, it is my first time to consult programming tips on this site as I was having a hard time to look for the solutions over the internet. My problem is, using vba, how can I show a msgbox stating there is a duplicate value on that particular column?
My table shows like this:
ExcelVisualAid.jpg
If I enter again "ec" on Agency Code and "3354" on Record No., the Maid No. (concatenated value) would be the same, Excel MsgBox should prompt me that there is already the same value generated and after I press OK button, Excel will undo/delete whatever I have entered on column H & I
Thanks in advance for everyone who can help me.
Bookmarks