将宏指定给按钮表单控件（有限制）

[英]Assign Macro to button form control (with restrictions)

本文翻译自 Sam 查看原文 2013/11/24 367 excel/ button/ vba/ excel-vba

I'm looking to do the following:

我想做以下事情:

Assign a macro to a form control button, but only let the user press this button once. Once the button is pressed once it shouldn't be possible to press it again. I'm trying to prevent accidental clicking of the button. The macro is sending a quantity to an accounting spreadsheet so I don't want to send anything twice by accident.

将宏指定给表单控件按钮,但只允许用户按此按钮一次。一旦按下按钮,就不能再次按下按钮。我试图防止意外点击按钮。宏正在向会计电子表格发送数量,因此我不想偶然发送两次。

1 个解决方案

#1

I guess you could use the "Enabled" property, like:

我想你可以使用“启用”属性,如:

Sub CommandButton1_Click()
    CommandButton1.Enabled = False
    ...
End Sub

智能推荐

注意！

本站翻译的文章，版权归属于本站，未经许可禁止转摘，转摘请注明本文地址：http://www.silva-art.net/blog/2013/11/24/d3447f93c211cb84f23afdb4940e3a44.html。

猜您在找

将单个键盘快捷方式指定给Web表单上的单选按钮 - Assign a single keyboard shortcut to a radio button on a web form VBA：将默认值指定给表单控件组合框 - VBA : Assign default value to a form control combo box 语义宏 - 将前一个宏指定给另一个宏 - Semantic Macro - assigning a previous macro to another 无法在Excel中指定宏 - Can't assign macro in excel Word宏以在宏之后取消选择内容控件 - Word Macro to Deselect a content control after macro

赞助商链接