Cell Conditions

  • Thread starter Thread starter Sloopy
  • Start date Start date
S

Sloopy

Hi - I have cell A-2 containing a drop down list. Once user chooses from
List, is there a way in Excel to "force"the user to also choose from drop
down list in cell B-2, which forces information to be entered into Cell C-3,
C-4 and C-5 or an error message or something? I'm trying to get the user to
COMPLETE all the information of a form. What's happening is the user is
providing only part of the information. Not sure if this is doable?
 
I would have to say no, Not within the spreadsheet itself. What you can do is
to create a userform with the ok button disabled untill all values are
entered.
 
Ok - thanks. I'll see about creating user forms.

Kent Prokopy said:
I would have to say no, Not within the spreadsheet itself. What you can do is
to create a userform with the ok button disabled untill all values are
entered.
Click to expand...
 
Back
Top