yande
New Member
Hi all Masters,
I want to make my scrollbar value increasing from 0 to 31 with formula +1.
I'd tried this coding but not work well.
>>> use code - tags <<<
I want to make my scrollbar moving by its own with VBA.
Please help me. Thanks in advance.
I want to make my scrollbar value increasing from 0 to 31 with formula +1.
I'd tried this coding but not work well.
>>> use code - tags <<<
Code:
Sub IncreaseValue()
Dim V As Integer
V = Sheet1.Range("A1")
Do Until V = 31
Sheet1.Range("A1").Value = V + 1
Loop
End Sub
I want to make my scrollbar moving by its own with VBA.
Please help me. Thanks in advance.
Last edited by a moderator: