Mr.G
05-28-2009, 05:22 AM
Is it possible to let a scroll bar determine how many times a macro must repeat it self?
Private Sub TextBox1_Change()
On Error GoTo Msg
ScrollBar1 = TextBox1.Value
Exit Sub
Msg:
MsgBox "Choose a number between 1-100"
End Sub
The macro is simple...
Sub Macro3()
Selection.Insert Shift:=xlToRight
End Sub
Thank you
Private Sub TextBox1_Change()
On Error GoTo Msg
ScrollBar1 = TextBox1.Value
Exit Sub
Msg:
MsgBox "Choose a number between 1-100"
End Sub
The macro is simple...
Sub Macro3()
Selection.Insert Shift:=xlToRight
End Sub
Thank you