I wasn't suggesting that the validation requires VB. Creating forms and handling form events does (unless MS has introduced new utilities to hide all that since last I used it).
Some of the most interesting things I have seen done with Excel did involve VB, and there are better tools to do most of those things. Gabor Grothendieck wrote: > > On Tue, Oct 21, 2008 at 3:18 PM, Ted Byers <[EMAIL PROTECTED]> wrote: >> There are tradeoffs no matter what route you take. >> You can do validation in Access as you can in Excel, but Excel is not >> designed to manage data where Access is, and both are crippled by their >> dependance on VB (a seriouusly broken language: fine for scripting MS > > Excel can do validation without VB. For example, you can restrict > data to a certain range of dates, limit choices by using a list, or > make sure that only positive whole numbers are entered all without > any VB. > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > > -- View this message in context: http://www.nabble.com/Staging-area-for-data-before-read-into-R-tp20075962p20099445.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
