Moving Horizontal ScrollBar

[arunakumari02]

Scrolling Horizontal ScrollBar

Hi

I have to scroll horizontal scrollbar and the scrollbar should move back 12 months and forward 24 months.

Any help is appreciated.

 

[DCrake]

Simple Software Solutions

In total you have 36 possible positions - 1 for each month

Set your min and max to 0 and 36

as the user slides the scrool bar it will increase / decrease the value automatically. As the number changes use this value to calculate the correct date/month

If ScroolbarValue <= 12 Then
   ScroolBarDate = DateAdd("m",-ScrollBarValue,Date())
Else
   ScroolBarDate = DateAdd("m",(ScrollBarValue-12),Date())
End If

CodeMaster:

ScroolBarMonth = Month(ScrollBarDate)

CodeMaster: