如何在Excel 2007中从VBA访问复选框 [英] How to access Checkbox from VBA in Excel 2007

问题描述

添加复选框时，如何访问VBA中的值？

When adding a checkbox, how do you access the value from VBA?

• 在Excel 2007中，在开发人员功能区上


• 插入，表单控件，复选框


• 将复选框重命名为chkMyCheck


• 将宏添加到复选框，我现在有Module1与chkMyCheck_Clicked

• In Excel 2007, on the Developer Ribbon
• Insert, Form Controls, Checkbox
• Renamed Checkbox to chkMyCheck
• Added Macro to checkbox, I now have Module1 with chkMyCheck_Clicked

以下所有失败

Sheets("Sheet1").chkMyCheck.Checked  
Sheets("Sheet1").chkMyCheck.Value  
Sheets("Sheet1").Shapes("chkMyCheck").Checked  
Sheets("Sheet1").Shapes("chkMyCheck").Value  
Sheet1.chkMyCheck.Checked  
Sheet1.chkMyCheck.Value  

Sheet1.Shapes（chkMyCheck）似乎找到该对象，但不显示任何可能返回检查状态的属性。

Sheet1.Shapes("chkMyCheck") appears to find the object, but does not expose any properties that look likely for returning the checked state.

推荐答案

想出来

If Sheet1.Shapes("chkMyCheck").ControlFormat.Value = xlOn Then
.....

这篇关于如何在Excel 2007中从VBA访问复选框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！