When cell A2 is A, Cell E2 automatically becomes data validity, the content is 2, 3, 5, 8
When cell A2 is S, Cell E2 automatically becomes data validity, the content is 1, 4, 6, 7, 9
Can someone please help me ? It would be much appreciated
When cell A2 is A, Cell E2 automatically becomes data validity, the content is 2, 3, 5, 8
When cell A2 is S, Cell E2 automatically becomes data validity, the content is 1, 4, 6, 7, 9
Can someone please help me ? It would be much appreciated
Last edited by rayhen; 12-22-2022 at 03:17 AM.
Create named ranges ListA and ListS
For DV
List
=IF(D2="A",ListA,ListS)
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Worksheet event is used.
code:
How to use workheet event the codePlease Login or Register to view this content.
Right click on Sheet tab --> view code
Visual Basic (VB) window opens.
Paste the code
Close the VB window.
Save the file as .xlsm
Last edited by kvsrinivasamurthy; 12-21-2022 at 11:03 AM.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Thanks to both of you, both methods can accomplish the task
WOW kvsrinivasamurthy you are awesome thanks for your help problem solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks