Difference between revisions of "A 'hello world' VBA program"
From Ribbon Commander Documentation
(→Creating a tab) |
(→Creating a tab) |
||
| Line 1: | Line 1: | ||
== Creating a tab == | == Creating a tab == | ||
| − | + | * Enter the code below in a standard VBA module | |
<syntaxhighlight lang="vb"> | <syntaxhighlight lang="vb"> | ||
Public Sub CreateMyUI() | Public Sub CreateMyUI() | ||
| Line 21: | Line 21: | ||
End Sub | End Sub | ||
</syntaxhighlight> | </syntaxhighlight> | ||
| + | * Run the sub to create an empty tab labeled 'My First Tab' | ||
| + | *: [[image: EmptyTab.png]] | ||
Revision as of 17:02, 10 March 2013
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'
-
