Data validation if Worksheet_change

Toto Li

New Member
Joined
Jul 4, 2020
Messages
2
Office Version
  1. 2010
Platform
  1. 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?
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
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.
 
Upvote 0
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).
 
Upvote 0

Forum statistics

Threads
1,213,494
Messages
6,113,981
Members
448,538
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top