vba 如何在 Excel 用户表单中添加帮助按钮

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/27516530/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-12 05:32:58  来源:igfitidea点击:

How do you add a help button to Excel userform

vbaexcel-2007userform

提问by chiangy77

I have a few different userforms in Excel 2007 right now and was wondering if I could add a "?" button next to the close symbol in the userform.

我现在在 Excel 2007 中有几个不同的用户表单,想知道是否可以添加一个“?” 用户表单中关闭符号旁边的按钮。

Alternatively, is there a way to display some text when I hover over a specific label

或者,当我将鼠标悬停在特定标签上时,有没有办法显示一些文本

回答by Mark Moore

The form property "WhatsThisButton" displays the question mark icon next to the close button, but this does nothing without creating an actual help file and assigning it to your form, this is not an easy thing to do. Far easier is to display text as you have described, each control has a "controlTipText" property that will display whatever text you enter in there, when your user hovers their mouse over the control

表单属性“WhatsThisButton”在关闭按钮旁边显示问号图标,但是如果不创建实际的帮助文件并将其分配给您的表单,这将不起作用,这不是一件容易的事情。正如您所描述的那样显示文本要容易得多,每个控件都有一个“controlTipText”属性,当您的用户将鼠标悬停在控件上时,该属性将显示您在其中输入的任何文本