Using XML in VBA

Introduction

Dynamic RibbonX controls are both

• Serializable to XML
• Instantiatable from XML

Serializing to XML

Public Sub SerializingButton()
 
    ' Create a new button
    Dim myButton As rxButton
    Set myButton = New rxButton
 
    ' Build up state
    With myButton
        .ID = "my_button"
        .Label = "My Button"
        .Enabled = rxTrue
        .Visible = rxTrue
        .keytip = "K"
        .ScreenTip = "My button screentip"
        .supertip = "My button supertip"
 
        ' Serialize to XML
        Debug.Print .XML
    End With
 
End Sub

The following xml code is printed out to the debug window:

<button screentip="My button screentip" supertip="My button supertip" enabled="true" label="My Button" visible="true" keytip="K" id="my_button"></button>