Hi, I want to display dates in cells N1:Z1. I want to be able to change the dates through a scrollbar. So, if the scrollbar is pressed right, the dates will increase going forward in the year and vice versa if the scrollbar is pressed left. This is drawn in the attached figure. Can someone help me figure out how to implement this? I will appreciate the help.
Best,
John.
^bump^ in case someone has ideas on this.
This uses the ActiveX scroll bar. It will show from 1 month before to 1 month after the year entered into M2. Is this what you are looking for?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks