Hi Sala

If the datasheet has to be an excel worksheet then you're now left with
macro programming/validation. And also risking that macros are disabled by
the user or the sysadmin, removing the whole logic.

Userforms use VBA, macros, programming code, and you can tame it to do
whatever cool things. But it has to be done, there are no "everything is
allowed and you'll be strictly validated doing it" methods available by
default. Liberty OR control, not both.

So either spend lots of hours (at $? each) programming this, buy a few
Access licenses (at $? each) or spend your users' time on awkward and
limited entries (at $? each), I believe that would be the options. Excel is
originally a spreadsheet, not a platform or a database, so she's not the one
to blame here.

(We may hope that someone proves me wrong here. Stranger things happen every
hour :-)

Best wishes Harald

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

I looked at the site but that's not the interface I want.
Insted of a 'form' view, it'd be easier for them if they
had it in 'datasheet' view.

I can't use MS Access because only a few users have it
(and I don't like the fact that you can only change one
cell at a time).

I want to keep it in an Excel worksheet, unlocked (so
copy/paste method can be used to quicken process) but at
the same time I'd like to mimic the Access table
property "LimitToList".

Any thoughts?
Sala