Data validation if Worksheet_change

Toto Li

New Member
Joined
Jul 4, 2020
Messages
2
Office Version
2010
Platform
Windows
Hello all!
I have 4 rows : Name, Address, E-mail, Phone ws2.Range("AN3:AN6")
Data exist: ws4.range("L8:AB5000")
Idea: Check if the customer has been registered with any of these details when cell value change: List.Show when Workshhet_change
Problem 1: The list should be displayed only once from any row, if more then one data matches.
Problem2: This range is also used to view the existing record. List does not need to be displayed.
Any idea for solution?
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

RayFrye

Board Regular
Joined
Jan 31, 2005
Messages
81
Office Version
365, 2019
It has been some time and no one has helped you. I would suggest that you chop your requirements up into tiny pieces. This will allow you to think thru your requirements and someone here to get a handle on where you start, what happens in the middle (multiple steps) and how you might end the effort before the cycle starts over. I think most folks here want to help but many of us are programmers and we think in terms of formulas, forms, key strokes, subroutines and error processing. When we think about Excel apps our heads explode until we get the app to subroutines, then we can do our thing. Just a thought. And try something yourself and let us know where your thought process failed. Not too many here, although there are some, will sit down and write the app for you.
 

mumps

Well-known Member
Joined
Apr 11, 2012
Messages
9,193
It would also be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheets. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).
 

Toto Li

New Member
Joined
Jul 4, 2020
Messages
2
Office Version
2010
Platform
Windows
Thank you!
Problem is solved.
 

Watch MrExcel Video

Forum statistics

Threads
1,102,565
Messages
5,487,592
Members
407,605
Latest member
PACULA

This Week's Hot Topics

Top