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

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

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


.

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


.

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


.



.

Hi Sala

You say Records. If this is strict data entries to rows then have a look at
John Walkenbach's enhanced Data form:
http://j-walk.com/ss/dataform/index.htm

HTH. Best wishes Harald


"Sala" skrev i melding
...
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.