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 | # Enter the code below in a standard VBA module | ||
| − | + | <syntaxhighlight lang="vb"> | |
Public Sub CreateMyUI() | Public Sub CreateMyUI() | ||
Revision as of 17:00, 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
