franswa3434
Board Regular
- Joined
- Sep 16, 2014
- Messages
- 69
Hey everyone,
I need to somehow create a formula or VBA (or any other option) to default a drop down in a cell, based upon the value of another cell, but still allow the user to select a different option. I am using a VBA to set it to the default, and can update the drop down, but it will not retain the new (non-default option) if I switch tabs or close out of the worksheet.
For example, if A1 <> "", then B2 (which has a Yes/No drop down) needs to default to "Yes", but yet needs to be able to be changed to "No" without automatically switching back if I go to a different tab or close out of the worksheet.
I tried using a VBA formula which stated if B2="No" then B2="No", elseif A1<>"" then B2="Yes", but it did not solve my issue.
Any thoughts?
I need to somehow create a formula or VBA (or any other option) to default a drop down in a cell, based upon the value of another cell, but still allow the user to select a different option. I am using a VBA to set it to the default, and can update the drop down, but it will not retain the new (non-default option) if I switch tabs or close out of the worksheet.
For example, if A1 <> "", then B2 (which has a Yes/No drop down) needs to default to "Yes", but yet needs to be able to be changed to "No" without automatically switching back if I go to a different tab or close out of the worksheet.
I tried using a VBA formula which stated if B2="No" then B2="No", elseif A1<>"" then B2="Yes", but it did not solve my issue.
Any thoughts?
Last edited: