rcicconetti
New Member
- Joined
- Jan 16, 2016
- Messages
- 34
I would like to use buttons to navigate up and down a list of dates (D44:D344) and display the date in Cell K22.
I've been searching for a macro to assign to each button (previous date, next date), that will not only navigate the list, but also respect the beginning/end of the list without producing an error. If at the top of the list and "previous date" is clicked, then K22 = D44. If at the bottom of the list and "next date" is clicked l, then K22= D344.
I've tried several different ways using IfMatch, Offset, setting variables, etc., but can't seem to get it working 100%.
Any help would be greatly appreciated!
I've been searching for a macro to assign to each button (previous date, next date), that will not only navigate the list, but also respect the beginning/end of the list without producing an error. If at the top of the list and "previous date" is clicked, then K22 = D44. If at the bottom of the list and "next date" is clicked l, then K22= D344.
I've tried several different ways using IfMatch, Offset, setting variables, etc., but can't seem to get it working 100%.
Any help would be greatly appreciated!