Difference between revisions of "Getting started in VBA"

From Ribbon Commander Documentation
Jump to: navigation, search
(Writing some code!)
 
(15 intermediate revisions by the same user not shown)
Line 1: Line 1:
__FORCETOC__
+
== 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
+
#: <syntaxhighlight lang="vb">?rxCustomUI.defaultInstance.targetOfficeVersion</syntaxhighlight>
+
#: 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)
+
#: [[image:UnsupportedExcelVersion.png]]
+
  
 
== Writing some code! ==
 
== Writing some code! ==
Line 17: Line 10:
 
* [[A 'hello world' VBA program]]
 
* [[A 'hello world' VBA program]]
 
* [[Creating our first button in VBA]]
 
* [[Creating our first button in VBA]]
* [[Creating a new global context in VBA]]
+
* [[Creating an rxCustomUI object with global dispatch scope in VBA]]
 
* [[Creating an rxCustomUI object with local 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 18: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.