需要VBA代码根据组合框选择检查是/否框 [英] Need VBA Code to check a Yes/No box based off a Combo box selection

问题描述

如果从组合框中选择了某个选项，请寻求有关代码的帮助以检查是否框。例如，如果我选择已购买从组合中，它将检查标记为已购买组件的是/否框。好像它应该很容易，但我有一个大脑放屁，似乎想到了怎么做。


感谢所有的帮助。

Looking for help on code to check the yes no box if a certain selection is picked from the combo box. For example if I pick "Purchased" from the combo it will put a check in the Yes/No box labeled "Purchased Component". Seems like it should be easy, but I''m having a brain fart and seem to think of how to do it.

Thanks for all the help.

推荐答案

DJ，


像往常一样，我们要求我们的海报到目前为止提交他们的作品。我们更愿意进行故障排除而不是创建。


此外，如果您当前的程序产生任何错误，那么了解它们也会有所帮助。

DJ,

As usual, we ask our posters to submit their work so far. We would much prefer to troubleshoot than create.

Also, if your current procedure produces any errors, it would be helpful to know those, as well.

已经完成了代码，因为我不知道除了在表单上的更新后，从哪里开始;之后不知道该怎么做。

Have done code yet, as I''m not sure where to start other than in the after update on the form; after that not sure what to do.

那么....


没有详细说明，根据信息这是不可能的给定，您将在组合框的AfterUpdate事件中有一个过程。检查组合框的值，并根据其值设置其他复选框的值。


我不能给你更多，因为我不知道组合框的内容，以及控件的具体名称。

Well then....

Without getting into specifics, which would be impossible based upon the information given, you would have a procedure in the AfterUpdate event of the Combo box. Check the value of the combo box and based upon its value, set the value of the other Check boxes.

I can''t give you more, because I don''t know the content of your combo box, nor the specific names of your controls.

这篇关于需要VBA代码根据组合框选择检查是/否框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！