Hey Harald,

I'll check out Tom's post.

You're exactly right. There are a lot of records and only
a handful of fields so most of the entering is
repetitive. Because of this, I want to give the users the
flexibility of 'copy paste' so they don't have to waste
time filling each box individually but at the same time, I
want to restrict them to using only the values in the data
validation.

Sala
-----Original Message-----
Hi Sala

See Tom Ogilvy's reply to the thread "Create a Dialog
Box" for userform
information. I wouldn't trust Clippy on that one :-)

How are you experiencing problems with Data validation ?
I know users can
paste to those cells and overwrite the whole thing, is
that what happens ?

Best wishes Harald

"Sala" skrev i
melding
...
Hi Harald,

My current system uses data validation (I thought it
had a
different name) and that's how I'm getting this problem.

What exactly is a userform? If can give me a few terms
here and there, I can use the assisstant to find out
the 'what' and 'how'.

Thanks
Sala


-----Original Message-----
Hi Sala

See if data validation will do what you want:
http://www.contextures.com/xlDataVal01.html

A worksheet isn't really a form in the strict meaning
of
the word. And
preventing incredible user actions is a complete
science
of its own. So
you're never 110% safe. But it's easier with a
userform +
VBA code than with
a worksheet.

HTH. Best wishes Harald

"Sala" skrev i melding
...
I'm in a bind....

I have a form that contains embedded drop down menus
(are
they called lists?). I want the users to select an
option
from the list but some users are getting creative and
finding ways to put non-list values in the cell. How
do I
prevent this?

Sala


.



.