A 'hello world' VBA program

From Ribbon Commander Documentation

Revision as of 17:09, 10 March 2013 by Rxdff15551 bb53 (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to: navigation, search

Creating a tab

Enter the code below in a standard VBA module

```
Public Sub CreateMyUI()
```
```
 
```

    ' Get a reference to the default rxCustomUI instance

```
    Dim myCustomUI As rxCustomUI
```

    Set myCustomUI = rxCustomUI.defaultInstance

```
 
```
```
    ' Create a new tab
```
```
    Dim myTab As rxTab
```

    Set myTab = myCustomUI.ribbon.tabs.Add(New rxTab)

```
 
```
```
    ' Give the new tab a label
```
```
    myTab.Label = "My First Tab"
```
```
 
```
```
 
```
```
    ' Render the UI
```
```
    myCustomUI.Refresh
```
```
 
```
```
End Sub
```

Run the sub to create an empty tab labeled 'My First Tab'

Code Analysis

    ' Get a reference to the default rxCustomUI instance
    Dim myCustomUI As rxCustomUI
    Set myCustomUI = rxCustomUI.defaultInstance

Retrieved from ‘https://documentation.ribboncommander.com/index.php?title=A_%27hello_world%27_VBA_program&oldid=243’