Difference between revisions of "Creating our first button in VBA"

From Ribbon Commander Documentation

Jump to: navigation, search

Revision as of 18:09, 10 March 2013

Contents

1 Prerequisites
2 Creating a button
3 Code Analysis
4 Adding a handler for the button's onAction delegate
5 Notes

Prerequisites

We recommend you go though A 'hello world' VBA program before going into this example.

Creating a button

```
Public Sub CreateMyUI()
```
```
 
```
```
    With rxCustomUI.defaultInstance
```
```
        ' Clear old state
```
```
        .Clear
```
```
 
```
```
        ' Add a new tab
```

        With .ribbon.tabs.Add(New rxTab)

```
            .Label = "My First Tab"
```

            ' Add a new group to our tab

            With .groups.Add(New rxGroup)

```
                .Label = "My Group"
```
```
 
```

                ' Add a new button to our group

                With .Buttons.Add(New rxButton)

                    .Label = "My Button"

```
 
```
```
                End With
```
```
 
```
```
            End With
```
```
        End With
```
```
 
```
```
        ' Render the UI
```
```
        .Refresh
```
```
    End With
```
```
 
```
```
End Sub
```

Code Analysis

Adding a handler for the button's onAction delegate

Notes

Retrieved from ‘https://documentation.ribboncommander.com/index.php?title=Creating_our_first_button_in_VBA&oldid=255’