Reply to thread

Message: [QUOTE="mwieder, post: 6271328"] Peter - first off, thanks for acknowledging and attempting to solve this challenging Excel issue. If we can just solve it so it handles the Enter key and the case wher eyou click of the sale after data entry, I'll worry about any other cases. But I can't even solve those! The idea of comparing Target and selection doesn't work because the value of Target is already changed when the SheetChange event gets fired and the new value entered is lost. We have to keep the behavior since that is how it used to work when we didn't support AutoCalc and now that we are going to support AutoCalc and ManualCalc, we have to handle this case. If anyone else is up to the challenge please help! thanks. [/QUOTE]