How do I display button properties in VBA from an excel sheet?

Navigation
-1

I have a spreadsheet with buttons that hide and re-display fields as the data set is populated. When I try to view or change the properties of the controls, I can not. VBA only shows the properties of the worksheet.

    
asked by anonymous 13.04.2017 / 16:46

2 answers

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 on that button / control. So maybe what you're looking for is Sub present in a worksheet module, not the simple module:

    
13.04.2017 / 18:41
0

There are 2 types of buttons to place directly on the worksheet. For both you access the properties by right clicking on them.

FortheFormControlbutton,youaccessthepropertiesbyaccessingthewindowinthe"Format Control ..." option:

FortheActivexControlbutton,the"Format Control ..." has very few options, but you can access the full properties window by selecting "Properties" from the context menu, clicking right click on the control. ActiveX is the type of control with properties similar to the UserForm controls in VBA:

    
13.04.2017 / 18:31
How to detect the largest word in a string in C? Error in Function, System.IndexOutOfRangeException