Hello,

We were looking for a couple of days to the forum and the internet to find something similar like this but we didn't find anything.

I am using an excel userform (Ver. 2003).
I have a spin button and a textbox.
I want the user to select from the spin button the end of month date from January 1st 2000 ("eomonth" function).
The result to be placed at sheet1 cell A1. Also the result to be on the textbox in userform the next time I will open the workbook.

I need a vba code for that to place on spin button and/or textbox and/or the userform.

Does anybody can help us with this?

We will appreciate this a lot!

Thank you very much in advance.