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 <
r.ted.byers@...> wrote:
> Ah, OK. That is new since I used Excel last.
>
> Thanks
>
> On Tue, Oct 21, 2008 at 5:52 PM, Gabor Grothendieck
> <
ggrothendieck@...> wrote:
>> You can create data entry forms without VB in Excel too.
>>
>> On Tue, Oct 21, 2008 at 5:09 PM, Ted Byers <
r.ted.byers@...> 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 <
r.ted.byers@...> 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@... 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@... 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@... mailing list
https://stat.ethz.ch/mailman/listinfo/r-helpPLEASE do read the posting guide
http://www.R-project.org/posting-guide.htmland provide commented, minimal, self-contained, reproducible code.