CODEWITHSUNDEEP
excel
raiden007
raiden007

Reputation: 7

scroll bar for my data in excel is not working properly

In the excel template that I am working on there is a scroll bar to change the month. but it is not working properly. when I click to change the month it jumps to the last month (it jumps from January to December. sometimes it works well but sometimes it just jumps). I checked for the format control and everything is ok, but the scroll bar is not functioning well. I hope you guys could help me. can you guys suggest me other ways to change the month other than a scroll bar? I am attaching a screenshot so you guys can understand it better. thanks! $B$3= 1 (default)

here is the screenshot: 1

here is the screenshot for the VB code: 2

Upvotes: 0

Views: 1264

Answers (1)

Ralph
Ralph

Reputation: 9434

I am not quite sure what your problem is. Yet, everything seems to work on my end without a problem:

enter image description here

BTW, your VBA code has nothing to do with the scrollbar and is not required as you can see in the screen-cast (shown above). So, maybe you can share your file with us (upload it some place and provide a download link here) so we can have a look at it. There is probably another problem in that file.

Upvotes: 1

Related Questions