It was in Excel 2003 too so you must not have used Excel for years. On Tue, Oct 21, 2008 at 6:36 PM, Ted Byers <[EMAIL PROTECTED]> wrote: > Ah, OK. That is new since I used Excel last. > > Thanks > > On Tue, Oct 21, 2008 at 5:52 PM, Gabor Grothendieck > <[EMAIL PROTECTED]> wrote: >> You can create data entry forms without VB in Excel too. >> >> On Tue, Oct 21, 2008 at 5:09 PM, Ted Byers <[EMAIL PROTECTED]> wrote: >>> >>> 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. >>> >> >
______________________________________________ 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.
