用户表单中的复选框 [英] Check Boxes in UserForms
问题描述
我想知道如何在VBA中编写以下代码
I am wondering how to code the following in VBA
我希望从列表中选择一个或多个复选框(在UserForm中),并通过选择所需的每个复选框将数据放入一个单元格,然后按CommandButton输入在单元格中选择作为数据的信息。
I wish to select one or more check boxes from a list (in a UserForm) and put the data into one cell by selecting each one required and then pressing a CommandButton to enter the information selected as data in a cell.
请帮助,因为这是一个工作项目,将有助于我的工作更轻松!!
Please help as this is a work project and will assist in making my job easier!!
推荐答案
当你说复选框列表时,我不明白。列表是什么意思?
I don't understand when you say list of checkboxes. What do you mean by list?
例如,我有一个插件,可以在很多选项卡上放置很多复选框(700+)。 tabpanel userform。 复选框的信息(用于测试的设备)位于数据库中。 当初始化插件时,我动态地将复选框放在
表格和变量数组中。
For example, I have an addin that puts a lot of checkboxes (700+) on numerous tabs on a tabpanel userform. The information (equipment used for testing) for the checkboxes is in a database. I dynamically put the checkboxes on the form
and in an variant array when the addin is initialized.
这篇关于用户表单中的复选框的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!