Forum Discussion

sf49ers19238597's avatar
sf49ers19238597
Iron Contributor
Jun 14, 2023

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.

 

 

 

Be very helpful get this working.

 

Thanks You sf49ers164480

excel
Macros and VBA
  • mtarler's avatar
    mtarler
    Silver Contributor
    Jun 15, 2023
    The calendar doesn't change for me if I manually change the date and I do not see anywhere in the formulas that would make me think it would. That said IF you go into Name Manager and change ScYear to point at that cell then it seems to work.
      • mtarler's avatar
        mtarler
        Silver Contributor
        Jun 15, 2023

        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.

         

Resources