This seems like it should be simple, but for the life of me I can't find a solution.
I have a list in cell A1 with Yes and No option. Cell A2 contains a number to be entered by the user, however I would like this cell to be changed to 0 if the selection from list in A1 is "No". Does anyone have a solution for this?
I think you would have to use event code to make the cell = 0 since it is a user input cell.
You can put this in the sheet code module and it will run when the value in Cell A1 changes.
Please Login or Register to view this content.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
Awesome that works great! Thanks. If I have other cells that I need to accomplish the same thing would I just put multiple versions of this code and change the cell references accordingly?
No, you cannot have multiple versions of worksheet event code. You can possibly incorporate the others into the same code. If you can explain the conditions I will try to modify the code for you.
You can have different code for different events, but only one code per event.
Last edited by JLGWhiz; 03-21-2019 at 05:14 PM.
Sorry I should have included that. I have multiple rows that need this logic A8:A28 has the list and change E8:E28 to 0 if "No". I know cell references differ a bit from my original post, but I just modified your code to reflect my actual cells. These are my actual cell references.
Be sure to delete the other code before trying to run this one.Please Login or Register to view this content.
Works perfect! Thanks
You're welcome, don't forget to mark the thread as solved.Originally Posted by Broncswon
regards, JLG
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks