Forum Discussion
sf49ers19238597
Jun 14, 2023Iron Contributor
I need hep with spin button to change dates
I add a spin button to change the year in cell D2 for last or next year. but the calendar is not changing dates on months. If I change year in d2 manually it is change to right days and dates. ...
sf49ers19238597
Jun 15, 2023Iron Contributor
How I do that
mtarler
Jun 15, 2023Silver Contributor
sf49ers19238597 Formulas -> Name Manager which pops up window as I show below then click on ScYear and edit formula in line at bottom. Basically delete what is there and then click on cell D2. Click check box to accept and close Name Manager.