• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part VII: Programming Excel > Advanced VBA Programming

Chapter 31. Advanced VBA Programming

by Bill Roy

  • Creating custom forms

    You learn to use VBA's integrated forms editor to create custom dialog boxes for interacting with the user.

  • Using ActiveX controls

    You add ActiveX controls to your forms to create dynamic, interactive applications, controlled by VBA.

  • Creating your own objects

    This advanced feature of VBA lets you define your own data objects, and reuse their code in many applications.

  • Introduction to API programming

    Using the programming libraries that are built into Windows, you can add even more functionality to your programs than is provided by VBA.

  • Creating PivotTables with VBA

    Use VBA to automate the creation of Excel PivotTables so you and your users can easily analyze data.

  • Creating toolbars with VBA

    Provide custom toolbars under VBA control, giving your users an easy and intuitive method for running your macros.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint