Dont know where to begin

[Triton225]

Hey guys. I am having a hard time with this. I have a project that I am working on, its just a simple list of folks who make purchases, who they are, what they paid....... Each person is given a purchase number, and they are in consecutive order. So if a person made a purchase today, lets say they are number 5, that same person could make another purchase a few weeks later, and the number would be, lets say 66. So there will be duplicates obviously if the person orders more than once.

Here is the problem...

I have a column for bounced checks. So if the customer gives us a bad check, i will put an 'X' in that column. My boss wanted to know if it is possible, while entering a person, could there be an alarm or pop up that will tell us that this person in the past has given us a bad check.

So, lets say someone places and order today, check bounces. A month from now they make another order, I type in the name... Can an alert pop up saying this person bounced a check on us a month earlier?

 

[shemayisroel]

Tritton225 Hi & Welcome,


Sounds like there may be a few types of different solutions for your problem, could you post some sample data using excel jeanie in order for the solution(s) be tailored to your data.

http://www.excel-jeanie-html.de/index.php?f=1

 

[jfklbj]

Something similar to this might work


Private Sub Worksheet_SelectionChange(ByVal Target As Range)
name = activecell.value
With Sheets("Test").Range("D13")
nitems = Range(.Offset(1, 1), .End(xlDown)).Rows.Count
If Intersect(target, Sheets("Test").Columns(5)) Is Nothing Then exit sub
For n = 1 to nitems
if Range(.offset(n,0)).Value = "x" and Range(.Offset(n,1)) = name then
msgbox "This guy's a deadbeat!"
End if
end with
next n
end sub