Difference between revisions of "A 'hello world' VBA program"

From Ribbon Commander Documentation
Jump to: navigation, search
(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">
+
<syntaxhighlight lang="vb">
 
Public Sub CreateMyUI()
 
Public Sub CreateMyUI()
 
      
 
      

Revision as of 17:00, 10 March 2013

Creating a tab

  1. 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