Re: QDE (Quick Date Entry)

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 09/02/04 

Date: Thu, 2 Sep 2004 19:32:33 +0200

Hi Harlan
[...]

> As I've pointed out in my 'technical' responses, neither event
handler
> does anything with partial date entries when users are entering dates
> into multiple cell selected ranges. That's the *most* *likely* usage
> scenario for your add-in. So your add-in doesn't convert short date
> entries upon entry in that most likely situation. The user would have
> to reselect all date entry cells after entry in order to convert
them.
> What's the advantage of doing that vs using a simple macro to convert
> short date entries in batch?

and as answered this is IMHO more an Excel 97 bug :-) This scenario
works without a problem in all other Excel versions. So we 'just' have
to workaround this Excel 97 behaviour.
And I agree with you that this is a very common scenario so we of
course have to solve it.

> You've got a problematic concept that can't be implemented real-time
> given the way Excel's event handlers actually work. What are the
> benefits vs more traditional conversion methods (macros)?

I think this is a user decision. Benefit: Real time conversion without
a helper column. Drawback: usage of event handlers. And IMHO we can
implement it in real-time also for Excel 97 (and if not we will include
this as draweback of using the addin in Excel 97)

Frank

Loading