Validating Excel
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 |
Validating Excel
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! * |
All times are GMT +1. The time now is 03:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com