使用宏更新某些连接器的显示颜色 [英] Update Display Color for certain connectors with Macro

问题描述

我有一张大图，大约400个连接器。每个连接器中的文本以团队的3个字符代码开头。我想创建一个请求3个字符代码的宏，然后循环遍历所有的conncetors和颜色连接器行Red和
如果它以输入的3个字符开头，则将它括起来。

现在我有一个为连接器数量执行的循环，我知道如何确定连接器是否是我想要的并进行更新。我遇到的问题是如何选择所有连接器。如果我选择全部，它也会形状和
然后我的循环数关闭，一些对象没有文本，所以代码失败。

谢谢

解决方案

此主题似乎与VBA编码有关，最好将您的问题发布到General Office Development Developer论坛

I have a large drawing, about 400 connectors. The text in each connector starts with a 3 character code for a team. I want to create a macro that request the 3 character code and then cycles through all the conncetors and colors the connector line Red and Bolds it if it starts with the entered 3 Characters.

Right now I have a loop that executes for the number of connectors and I know how to determine if the connector is one I want and to do the updates. The issue I have is how to just select all the connectors. If I select all, it does the shapes as well and then my loop numbers are off and some objects do not have the text so the code fails.

Thanks

解决方案

Hi,

This topic seems to be related to VBA coding, better to post your question to the forum for General Office Development Developer

http://social.msdn.microsoft.com/Forums/office/en-us/home?category=officedev

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

Tony Chen
TechNet Community Support

这篇关于使用宏更新某些连接器的显示颜色的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！