Modifying object properties in Excel VBA project RRS feed

  • Question

  • In the past (several years ago) I have been able to modify certain properties of UserForms in an Excel VBA project. These include:

    -        Name of the UserForm

    -        Tab order of controls on a UserForm

    -        Size and position (using precise numeric values) of controls on a UserForm

    -        Name on controls on a UserForm

    Now I can’t find any way to do this.

    Have these capabilities been removed from a newer version of Excel and/or VBA or have I forgotten some secret method?

    I am now using Excel version 16.0.12430.20288 but this problem has been present since long before this version was installed.

    Thanks for any help.


    Thursday, March 5, 2020 7:15 PM