Difference between revisions of "Getting started in VBA"

From Ribbon Commander Documentation
Jump to: navigation, search
(Referencing the library)
Line 11: Line 11:
 
#: [[image:UnsupportedExcelVersion.png]]
 
#: [[image:UnsupportedExcelVersion.png]]
  
== A 'hello world' project in VBA ==
+
== Writing some code! ==
 +
* [[A 'hello world' VBA program]]

Revision as of 16:44, 10 March 2013

Prerequisites

Before you get started install Dynamic RibbonX on your PC (see Installation)

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)
    VBAReference.png
  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 is for excel in this case)
    UnsupportedExcelVersion.png

Writing some code!