Data Validation Auto Select

AllanSull

Board Regular
Joined
Oct 21, 2013
Messages
105
Is there a way to automatically populate a dropdown if that dropdown only has 1 option to select from?

Mlcbqi.png


So when option 1 is selected, in this example "Yes", the only available value in Option 2 is also "Yes", so instead of making a user select this can it be automatically selected?
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Chris Macro

Well-known Member
Joined
Nov 2, 2011
Messages
1,341
Sure, just put an IF function in the cell. As long as the outputs don't conflict with the data validation you're golden. Try something like this: =IF(C2="Yes","Yes","")
 

AllanSull

Board Regular
Joined
Oct 21, 2013
Messages
105
It won't allow me to use a formula in the cell, I get the error message "A user has restricted values that can be entered into this cell".
 

Chris Macro

Well-known Member
Joined
Nov 2, 2011
Messages
1,341
What version of Excel are you using? I was able to do this in Excel 2007. Can you show me the exact formula you input? Are you using the List Data Validation option?
 

AllanSull

Board Regular
Joined
Oct 21, 2013
Messages
105
Excel 2010. I am using the List Data Validation, as shown in my screenshot in Post#1.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,122
Messages
5,599,826
Members
414,341
Latest member
Mohammedsobhey

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top