目标栏&排问题 [英] Target Column & Row question
问题描述
我正在尝试在任何列中的任何行（基于代码地址更改）中的任何单元格，如果数字低于< 10则会说出一个单词并且如果数字结束则播放声音（wav）> ; 10.
此代码适用于所有A列，但在B列上它使用C列的语音和声音。
感谢您的帮助。
I am trying to have any cell that in any row in any column (based upon code address change) that would Speak a word if the number is Under <10 and play a sound (wav) if the number is over >10.
This code works fine for all of column A, but on column B it uses the Speech and Sound from column C.
Thank you for your help.
推荐答案
我试图在任何行中都有任何单元格在任何列中（基于代码地址更改）如果数字低于< 10则会说出一个单词并且如果数字超过< 10则播放声音（wav）。
此代码有效对于所有列A都很好，但在列B上它使用来自列C的语音和声音。
I am trying to have any cell that in any row in any column (based upon code address change) that would Speak a word if the number is Under <10 and play a sound (wav) if the number is over >10.
This code works fine for all of column A, but on column B it uses the Speech and Sound from column C.
（为了清楚起见，我修改了代码的缩进 - 至少在我发现它更清楚时，无论如何。 :)）
我不熟悉相交功能，因此可能偏离此处。但肯定这行
(I''ve modified the indenting of the code for clarity - at least in I find it clearer, anyway. :))
I''m not familiar with the Intersect function, so may be way off-track here. But surely this line
感谢您的帮助。
您对如何使这项工作有任何想法吗？
Thank you for your help.
Do you have any ideas on how to make this work.
我不认为我完全理解应该发生什么。我的意思是，我遵循基本的 if_blah_play_sound_otherwise_speak ，但不完全 所有这一切应该发生，并且它不在哪里。
正如我所说的，我对Intersect（）并不熟悉，但看起来好像你正在应用某种业务规则。在哪里你将执行各种行动。只需要了解代码背后规则的更多细节。
I don''t think I understand well enough exactly what is supposed to happen. I mean, I follow the basic if_blah_play_sound_otherwise_speak thing, but not exactly where all this is supposed to happen, and where it isn''t.
As I said, I''m not familiar with Intersect( ) but it looks as though you are applying some sort of "business rules" on where you will perform the various actions. Just need some more detail on the rules behind the code.
这篇关于目标栏&排问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
