I am trying to update a datatbase from excel. How do I
validate the data entered in a paricular cell (NOT COLUMN)
Could someone help me out

On Wed, 20 Aug 2003 02:25:54 -0700, "Joshua"
wrote:

I am trying to update a datatbase from excel. How do I
validate the data entered in a paricular cell (NOT COLUMN)
Could someone help me out

You can do some rudimentary data validation through the Data menu,
Validation... option. Just like any normal format, you can copy the
validation settings through copying and pasting. More than that I
couldn't say considering that I don't know what type of validation you
want to do. Also, there's no way to prevent the validation from being
overridden by simply pasting values from other cells into the
validated ones. Excel doesn't really provide strong validation
options, unless you do a fair amount of behind the scenes VBA work to
achieve them.

---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *