Excel Active X复选框默认情况下未选中 [英] Excel Active X Checkbox Uncheck by default

问题描述

我有一个用于激活x复选框的代码

Private Sub CheckBox2_Click()
    Range("RowBlock2").EntireRow.Hidden = CheckBox2.Value
End Sub

复选框具有单击标志.我不知道为什么

当我单击它们时，它们显示隐藏的行.

有什么办法可以修复代码，因此默认情况下不会选中复选框

谢谢

我敢肯定这很简单，但我一直在努力寻找解决方法，以解决此问题.

解决方案

您可以在属性窗口中设置值"，右键单击复选框以选择属性，从窗口中将值设置为true(选中)，false(未选中)./p>

I have this code for an active x check box

Private Sub CheckBox2_Click()
    Range("RowBlock2").EntireRow.Hidden = CheckBox2.Value
End Sub

the check boxes have a click sign in them. I don't know why

When I click on them they show the hidden rows.

is there any way to fix the code so the check boxes are not ticked in by default

thank you

I'm sure its something simple but Ive been searching for hours trying to fix this any help appreciated

解决方案

You can set the Value in the properties window, Right click the checkbox select properties, from the window set the value to true for checked, false for unchecked.

这篇关于Excel Active X复选框默认情况下未选中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！