cyberdimitri
New Member
- Joined
- Nov 4, 2012
- Messages
- 49
- Office Version
- 365
- Platform
- Windows
Hi,
Here's my problem:
I have created a list in cells E1-E10 where the 1st entry is "Please select".
If A1 is empty, B1 must also be empty.
If there is any value in A1, then B1 should show in a dropdown the list from E1-E10.
If A1 changes after user selects a value from the dropdown for B1, B1 must reset to "Please select" again.
If A1 is cleared after user selects a value from the dropdown for B1, then B1 must be cleared too.
Anyway this is possible?
I have no knowlegde of VBA (I believe it's required) so I would appreciate any help to be spelt out.
Thanks!
Here's my problem:
I have created a list in cells E1-E10 where the 1st entry is "Please select".
If A1 is empty, B1 must also be empty.
If there is any value in A1, then B1 should show in a dropdown the list from E1-E10.
If A1 changes after user selects a value from the dropdown for B1, B1 must reset to "Please select" again.
If A1 is cleared after user selects a value from the dropdown for B1, then B1 must be cleared too.
Anyway this is possible?
I have no knowlegde of VBA (I believe it's required) so I would appreciate any help to be spelt out.
Thanks!