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?
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?