Test for >1 occurances meet same criteria. Display address in MsgB

J

John

In Sheet1 I want to test col. W for more than one occurances of the same text
value and at the same time both/all matches a constant text value in col. P
on the same row. The criteria/text in col P is: "Started". The values in col.
W are picked through validation from a named range called "Cell_No-Prod". The
text is: "Cell1", "Cell2",...."Area1", "Area2",.....etc.

I want to display a MsgBox with the text: "You have entered [text value from
W] [n] times. Max allowed is one. Please correct. The repeated entry are in
row [row numbers]."

The user shall be able to close the MsgBox, correct the wrong entry, before
a new warning goes off. 3 minutes would be enough.

I know how to make user forms, but I'm stuck on the code/test for repeating
values.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Loop Through Text and Test for Scenarios Q 31
A For Each in Range... with a .Find(what:="TJ", ... in it problem 15
Automatic Cond Formatting of multiple columns based of values of 1 2
Sum total using Sumproduct if two criteria met 5
Help with conditional formatting in Excel 2010 8
Code to copy column in sheet 1 to column in sheet 2 based on matched criteria 0
Changing values in column 1 and 2 based on values in col 3 & 7 1
Check for values in column A and if found then column B must have value. 3

Top