Private Sub UserForm_Initialize()
With Me
With .Slider1
.Max = Me.ListBox1.Width * 2
.SelStart = .Max / 2
End With
With .ListBox1
.BorderColor = RGB(127, 157, 185)
.AddItem "Hans Magnus Enzensberger"
.AddItem "Irmgard Waltraut Schmidt"
.AddItem "Karl Müller Lüdenscheid"
End With
With .ListBox2
.BorderColor = RGB(127, 157, 185)
.AddItem String(30, "a")
End With
End With
End Sub
Private Sub Slider1_Scroll()
With Me
.ListBox1.Width = .Slider1
.ListBox2.Left = .ListBox1.Width + 15
.ListBox2.Width = Me.Width - .ListBox1.Width - 30
End With
End Sub
Private Sub cmbCancel_Click()
Unload Me
End Sub
|