Select from drop-down box before moving on
 

I have a drop-down box that has the choices yes/no. It is essential that the
user make a selection in these boxes. Is there a way to not allow the user to
move forward in the worksheet without making a selection in this box?

Thanks!

Select from drop-down box before moving on
 

Yes, there is, but what constitutes "move forward"? What is it that he can
do that you don't want him being capable of doing before making that
selection? Excel can recognize many actions by the user that can trigger a
look-see by Excel to make sure such-and-such has been done. What actions by
the user do you want to use as a trigger to check that selection? HTH Otto
"dme82" wrote in message
...
I have a drop-down box that has the choices yes/no. It is essential that
the
user make a selection in these boxes. Is there a way to not allow the user
to
move forward in the worksheet without making a selection in this box?

Thanks!