Excel：由于计算而导致单元格值更改时触发事件 [英] Excel: Trigger Event when Cell Value Changes due to Calculation

问题描述

我有一个电子表格（Excel 2003 *）


C列变为Y当在该行输入所有必要的数据时。我希望当C列中的值更改为活动行的Y时，将显示一个消息框。


我正在使用此代码，但每次任何单元格变换时它都会触发。

I have a spreadsheet (Excel 2003*)

Column C changes to "Y" when all the necessary data has been input in that row. I want a message box to appear when the value in column C changes to Y for the active row.

I am using this code but it fires every time any cell chnges.

展开 | 选择 | Wrap | 行号

推荐答案

请包含没有它的过程声明行，并且在您的问题中没有任何解释，我们不知道如何触发此代码。这似乎很矛盾，但很难说大部分重要信息都缺失了。

Please include the procedure declaration line as without it, and without any explanation in your question, we have no idea how this code is triggered. It seems contradictory, but its hard to tell with most of the important information missing.

Phil：

*对不起，他们只给了我2003

Phil:
*Sorry they only gave me 2003

你还想要另一个版本的地球？ 2003年是长期发布的最坚实可靠的版本。 2010年最终可能会达到这种声誉，但它有办法达到2003年所获得的地位。

What on Earth would you want another version for? 2003 is the most solid and reliable version released for a good long time. 2010 may attain that reputation eventually, but it''ll have a way to go to reach the status 2003 has earned.

对不起，我已将代码放在工作表中进行计算。

Sorry, I have put the code in worksheet on calculate.

列C不能改为Y。

我假设列C中的单元。更改为Y。

如果是这样，此代码将看到如果该单元格包含Y。

将其放入工作表模块中。

Column "C" can''t change to "Y".
I assume that a cell in column "C" is changed to "Y".
If so, this code will "see" if that cell contain "Y".
Put it in the sheet module.

展开 | 选择 | 换行 | 行号

这篇关于Excel：由于计算而导致单元格值更改时触发事件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！