在新选项卡中打开链接
  1. Copilot 答案
    TheSpreadsheetGuru
    https://www.thespreadsheetguru.com › build-modern-vba-userforms

    How To Build A Modern-Looking VBA Userform

    • Let’s face it, VBA Userforms haven’t had much love from Microsoft over the past 10 or so years…..and it shows! Unfortunately, while Excel’s UI gets a fresh paint coat every 3-4 years, the userform controls still look lik… 展开

    Formatting The Userform Object

    It’s very important to keep in mind what your overarching formats will be when first building a Userform. Properties that are shared between all controls (such as Font color and BackC… 展开

    TheSpreadsheetGuru
    Formatting Textbox Controls

    TextBox controls allow users to enter information into them and are controls I see quite frequently while interacting with userforms. To modernize these controls, you’ll want to tw… 展开

    TheSpreadsheetGuru
    Create Your Buttons in Excel

    All the property changes so far have been rather painless, but here is where the extra effort will come into play. But don’t worry, this time spent will be well worth it! I will typically make b… 展开

    TheSpreadsheetGuru
    Adding The Hovering Effect with VBA

    I am an absolute sucker for hovering effects on buttons. I think they are so simple and elegant but give the user the most subtle of clues of where one might want to click. This effect has erase… 展开

    TheSpreadsheetGuru
    How do I create a custom user form?
    You can design your own custom user forms by inserting a userform into the Visual Basic Editor (VBE) You do this by selecting Insert | UserForm on the VBE menu bar. Click on ‘UserForm’ and a new blank form will appear ready for you to develop on
    automateexcel.com