Difference between revisions of "Getting started in VBA"

Revision as of 21:49, 14 March 2013

Before we start

Before we get started, you need to:

• Install the Dynamic RibbonX framework
• Reference the Dynamic RibbonX library

Referencing the library

1. Create a new project in your favourite office application
2. Add a VBA reference to the Dynamic RibbonX library (Tools->References)

   

3. The library is now ready to use. In the immediate window enter

   ?rxCustomUI.defaultInstance.targetOfficeVersion

   This should print the major version of the office platform you are using. If you are running in an older version of office you will get a runtime error instead (the error message here is for excel)

   

Writing some code!

It is recommended that you go through the examples below in the order in which they appear, as each example builds up on previous ones.

• A 'hello world' VBA program
• Creating our first button in VBA
• Creating an rxCustomUI object with global dispatch scope in VBA
• Creating an rxCustomUI object with local dispatch scope in VBA