Difference between revisions of "Getting started in VBA"

From Ribbon Commander Documentation
Jump to: navigation, search
 
(25 intermediate revisions by the same user not shown)
Line 1: Line 1:
__FORCETOK__
+
== Before we start ==
== Prerequisites ==
+
Before we get started you need to:
Before you get started install Dynamic RibbonX on your PC (see [[Installation]])
+
* [[Installation | Install the Ribbon Commander Framework]]
 
+
* [[Activation | Activate the Ribbon Commander Framework]]
== Referencing the library ==
+
* [[Referencing the Ribbon Commander library in VBA | Reference the Ribbon Commander library]]
# Create a new project in your favourite office application
+
# Add a VBA reference to the Dynamic RibbonX library (Tools->References)
+
#: [[image:VBAReference.png]]
+
# The library is now ready to use. In the immediate window enter
+
#: <pre>?rxCustomUI.defaultInstance.targetOfficeVersion</pre>
+
#: 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)
+
#: [[image:UnsupportedExcelVersion.png]]
+
  
 
== Writing some code! ==
 
== 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]]
 
* [[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]]
 +
* [[Using XML in VBA]]
 +
* [[Using events in VBA]]

Latest revision as of 19:24, 19 October 2013

Before we start

Before we get started you need to:

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.