Custom User Forms

  • Thread starter Thread starter Sandi Rush
  • Start date Start date
S

Sandi Rush

Hello All:

I know.... "the only 'stupid' question, is the one that's
not asked.....

Hopefully, I won't look like "too" much of a novice. Here
goes,

I have a elderly user, who is not overly comfortable with
using Excel, and is used to the "dumb terminal" approach
of data entry. Not that I don't want her to learn, she is
just extremely hesitant.

Anyway, I would like to create a custom form for her to
enter information into, which then populates a "hidden"
worksheet. Would need to have a couple of Validation
fields, i.e. only specific entries accepted.

Any hints on best way to start? All advice welcome.....

TIA,
Sandi
 
Sandi,

If your worksheet is set up as a regular database-style table (headings at
top, followed by one-row-per-record records, you may be able use Data -
Form. If you want to make a custom form, one must be created in vba.

Using worksheet protection, you can keep a user from entering stuff into
cells they shouldn't, such as cells with formulas. Data - Validation is
straightforward, and can put a prompt when the user has selected the cell,
as well as your "error" message when they violate the validation rules.

You may find that Access will let you make a more user-friendly application
for something like this. It can be set up so that when the file is opened,
it goes straight to the entry form (or to a menu you've created).
Absolutely minimal user skill required, and the user never sees any Access
stuff, only your stuff. Excel is a bit more heavy-duty.
 
Earl:

1st: Thanks for the prompt reply!

I was aware of the Data-Form option, but can you use it
for a "hidden" worksheet. I'd really prefer that she just
see the entry form.

I'm not sure I know enough about VBA to create form, but
will make an attempt.

As well, I have a "seat" license of Access 2000. Is there
maybe a "runtime" version of Access 2000?

TIA,
Sandi
 
Earl:

Thanks so much for your prompt reply! I used the sample
provided in article 161514, and it works great.

I imagine I'll have a lot of late nights coming up while
I "perfect" the worksheet!

Thanks again,

Sandi
 
Back
Top