Set Userform Transparency(Opacity) With Slider

            Transparency of userform can be set easily with slider control and VBA codes.

excel userform transparency

VBA codes to set userform opacity:
Private Sub Sliderk_Scroll()
    Call SetOneValueSlider
End Sub

Private Sub SetOneValueSlider()
   Dim bytOpacity As Byte

bytOpacity = Sliderk.Value
...
...
End Sub

excel vba slider control



Read more ...