Creating our first button in VBA

Prerequisites

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

Creating a button

Enter the code below in a standard VBA module

```
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

' Add a new group to our tab
With .groups.Add(New rxGroup)
    .Label = "My Group"
    '...
End With

Each rxTab object has a collection of rxGroup objects (accessible through its .groups property). Here we add a new group to our tab's groups and label it 'My Group'

' Add a new button to our group
With .Buttons.Add(New rxButton)
    .Label = "My Button"
 
End With

Each rxGroup object has a collection of rxButton objects (accesible through its .buttons property). Here we add a new button to out group's buttons and label it 'My Button'

Creating our first button in VBA

Contents

Prerequisites

Creating a button

Code Analysis

Adding a handler for the button's onAction delegate

Notes

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Search

Navigation

Tools