forms

  • Thread starter Thread starter CG
  • Start date Start date
C

CG

I have some worksheets that act as forms. I want to protect them as forms
and have the fields that require data, I want to make those fields required
with some kind of response from the user. Much like they do in Access, and
if possible give them some choices for the fields and let them have the
option to enter in their own response.

Is this possible?
Thanks
 
CG,

Data - Validation has some good stuff you can use to get drop-down menus
with choices, validate (limit to certain values) what's entered, etc.

As for requiring an entry, you can use formulas that post messages when
information is missing, or use some macro code that runs at certain times.
You have to decide when that will be enforced (before the user leaves a
cell, leaves that row, leaves the sheet, etc.). You don't want the user
getting stuck where he can't go on if he doesn't have an entry, or you'll
have frustration on his part, and he'll become what we call a
user-unfriendly.
 
Back
Top