Hello,
I have never used VBA. I saved my excel file in xlsm and put this code:
But its not working. The idea is when i change my first dropdown menu the second one to be null.Please Login or Register to view this content.
Hello,
I have never used VBA. I saved my excel file in xlsm and put this code:
But its not working. The idea is when i change my first dropdown menu the second one to be null.Please Login or Register to view this content.
Last edited by jeffreybrown; 08-20-2017 at 09:39 AM. Reason: Please use code tags!
It's not working because the code is waiting for a manual change to be made in D1. Since the change is being made automatically, the code doesn't fire. You can try using a dropdown change event like so...
Place the code in a regular module, not a class modulePlease Login or Register to view this content.
Pinkoto-vba-excel-null-the-value-of-a-cell-when-the-value-of-another-cell-changes-test101.xlsm
Last edited by gmr4evr1; 08-20-2017 at 10:47 AM. Reason: Added attachment
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
thank you!
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks