We use a data validation in a cell in a form.
Let's say this is with three 'choices': 'choose an option, Yes, No'
Of course the first one is an encouragement to choose an option. So you want either the Yes or the No to be choosen.
Is there a way to force this or give a warning if this cell stays at 'choose an option'?
Frans
Hello Frans,
No such option if you only are looking at data validation drop down list, but I can imagine that you can build such control with VBA. By using a data entry form you are probably using the best option for such.
If you are good with just having something that visualize there is something missing then you can use conditional formatting, but that will of course not force the user to correct the missing data, unless you build in for example a calculation logic that only calculates if all needed data exists.
Br,
Anders
Thanks Anders! We will use the conditional formatting, that's a good idea. The 'choose' text gives the Red cell and maybe that will trigger the user to change it in no color by choosing one of the options.
Frans
