单击另一个按钮后，VBA表单控制按钮需要消失 [英] VBA Form Control Button Needs to Disappear After Another Button is Clicked

问题描述

因此，当我单击另一个按钮时，我想使一个Form Control Button NOT和ActiveX Command Button消失.通常，如果它是一个ActiveX命令按钮，我会使用:

So I have a Form Control Button NOT and ActiveX Command Button that I want to make disappear when another button is clicked. Normally if it was a ActiveX Command Button i would use:

ButtonName.Visible = False

在另一个按钮触发的代码中.但是我不知道如何使用表单控件按钮，因为据我所知，它们不像ActiveX Command Button那样具有名称?

in the code that was triggered by the other button. However I dont know how to get that work with a Form Control Button as they dont have name like a ActiveX Command Button does so far as I know?

我只想将要消失的按钮更改为ActiveX Command Button，但这样做时，我会遇到以下问题:按钮格式更改，单击时文本大小增加，单击时按钮大小改变等.

---

I would just change the button I want to disappear to a ActiveX Command Button but when I do that I have issues with the buttons format changing, text sizes up when they are clicked, buttons change size when clicked, etc.

推荐答案

.Shapes("button 1").Visible = False

这篇关于单击另一个按钮后，VBA表单控制按钮需要消失的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！