-1
I have a spreadsheet with buttons that hide and re-export fields according to the filled data set. When I try to see or change the properties of the controls, I can’t. VBA only shows the properties of the spreadsheet.
2 answers
0
There are 2 types of buttons to be placed directly on the spreadsheet. For both you access the properties by right-clicking on them.
To the button of Form Control, you access the properties by accessing the window in the option "Format Control...":
To the button of Activex Control, "Format Control..." has very few options, but you can access the full properties window by selecting "Properties" with the context menu, by right-clicking on the controller. Activex is the type of control with properties similar to Userform controls, in VBA:
0
Your problem is a bit confusing, but if you are trying to find the code that a button runs, maybe it has been associated with a specific event about that button/controller. So maybe what you’re looking for is a Sub present in a spreadsheet module, and not in the simple module:
-
I’m sorry if I haven’t made myself clear. Actually, the code and function of the button is not the case. Regardless of the function, what I want is to access the control properties (name, color, visibility, etc.). Even in Design mode and with the Edit Button, when I click on the Properties icon, it only shows me the properties of the worksheet. From the button, the most I can edit is the text. My Excel is the 2010.
-
You must be using a form button, so instead of an Activex button!
Browser other questions tagged excel vba property controls
You are not signed in. Login or sign up in order to post.
What version of excel are you using? only then can we answer for sure
– Solano