Programming Excel with VBA and .NET

TabStrip Members

Use the TabStrip control to organize groups of settings for a similar set of controls. In addition to the members listed for the general Control object, the TabStrip control has the following members. Key members (shown in bold) are covered in the following reference section:

BackColor	ClientHeight
ClientLeft	ClientTop
ClientWidth	Enabled
Font	ForeColor
MouseIcon	MousePointer
MultiRow	SelectedItem
Style	TabFixedHeight
TabFixedWidth	TabOrientation
Tabs	Value

The TabStrip control doesn’t automatically show or hide pages of controls the way that the MultiPage control does. Instead, use it to display groups of similar settings. The following code demonstrates that technique by using a tab strip control to display the attributes and contents of the XML files in the current workbook’s folder:

' Create a tab for each .xml file. Private Sub UserForm_Initialize( ) ' Requires reference to the Microsoft Scripting Runtime. Dim fo As New filesystemobject, fld As Folder, _ f As File ' Get the workbook folder. Set fld = fo.GetFolder(ThisWorkbook.Path) ' Delete all the tabs from the TabStrip control. TabStrip1.Tabs.Clear ' For each file in the folder. For Each f In fld.Files ' If the file is XML. If fo.GetExtensionName(f) = "xml" Then ' Create a tab for it. TabStrip1.Tabs.Add , f.name End If Next ' TextBox properties txtFile.MultiLine = True txtFile.ScrollBars = fmScrollBarsBoth txtFile.TabKeyBehavior = True End Sub   ' Display the attributes for ...