如何检查excel表格宏是否正常工作？ [英] how to check excel sheet macros are working properly?

问题描述

如何检查我们在Excel工作表中应用的宏是否正常工作????

How to check that the macros we have applied in excel sheets is working properly????

推荐答案

Tarun.KSs的回答可能听起来很轻浮，但是事实上，它是唯一能说出来的方式。

使用任何形式的软件 - 而宏是软件的一种形式 - 唯一的方法来判断它是否正常工作（即完全按照你的意图去做，而不是你说的要做的就是运行它看看。





运行时它没有给出任何错误...... ......我只是想测试它是如何工作的





你有什么样的答案？想？ 运行宏并确保发票表中的单元格E162包含179.66？



您希望我们如何回答这个问题？我们不知道你的宏做了什么，所以我们怎么可能告诉你如何测试它们是否正常工作？缺少检测到的错误并不意味着宏工作。只有你可以为他们设计一个测试：我们甚至不知道他们正在操纵什么样的数据！



（这不是提示：发布你的宏 - 我不想要它们！）

Tarun.K.S.s' answer may sound flippant, but it is in fact the only way to tell.
With any form of software - and macros are a form of software - the only way to tell if it is working "correctly" (i.e. doing exactly what you intended it to do, rather than what you told it to do) is to run it and see.


" actualy its not giving any error while running......... I just wanted to test that how it works"


What kind of answer do you want? "Run the macro and make sure that cell E162 on the "Invoices" sheet contains 179.66?"

How do you expect us to answer that? We don't know what your macros do, so how could we possibly tell you how to test if they work properly? A lack of detected errors does not mean a macro works. Only you can design a test for them: we don't even know what kind of data they are manipulating!

(And that is not a hint: "post your macros" - I don't want them!)

你好，



添加一个手表或代码块进行调试可以得到你想要的输出。

调试也会悬停在每一行上以便知道执行价值看。



做出回复!!!!!

谢谢

Hi ,

Adding a watch or Block of code to debug can get u intended output .
Debug also and hover on each line to know the execution value to see .

Do Reply !!!!!
Thanks

这篇关于如何检查excel表格宏是否正常工作？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！