A 'hello world' VBA program

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

Jump to: navigation, search

Creating a tab

  • Enter the code below in a standard VBA module
  1. Public Sub CreateMyUI()
  2.  
  3.     ' Get a reference to the default rxCustomUI instance
  4.     Dim myCustomUI As rxCustomUI
  5.     Set myCustomUI = rxCustomUI.defaultInstance
  6.  
  7.     ' Create a new tab
  8.     Dim myTab As rxTab
  9.     Set myTab = myCustomUI.ribbon.tabs.Add(New rxTab)
  10.  
  11.     ' Give the new tab a label
  12.     myTab.Label = "My First Tab"
  13.  
  14.  
  15.     ' Render the UI
  16.     myCustomUI.Refresh
  17.  
  18. End Sub
  • Run the sub to create an empty tab labeled 'My First Tab'
    EmptyTab.png

Code Analysis

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