Hi everyone, I may not be wording my search correctly as I have not found the answer to this question. How do I create a scrolling bar for a single cell. I have a workbook with the month (R3) and would like to be able to use the scroll button on the mouse to select the proper month. Subsequently, I would also like to have the date (R4) 1-31 be on a scrolling bar. Can anyone help me on this? Thanks in advance.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Scrolling bar in a single cell
Eric W
MrExcel MVP
- Joined
- Aug 18, 2015
- Messages
- 13,335
Go to the Developer tab. If it's not showing, click File > Options > Customize Ribbon > and check the Developer box on the right. From the Developer tab, click Insert > Spin Button. Use the mouse to put it where you want. Right click on it and select Format Control, and you can say where the value should go, as well as the lower and upper values (1-12, or 1-31).
Hope this helps.
Hope this helps.
Upvote
0
Similar threads
