Excel spin button on Userform

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.

First of all, I want to thank you for your replies!

I have attached the file with the userform.


Thank you again!

Here is a modification of your file that fixes things up. Note that I set your two textboxes to "not enabled" because it appears that you want to manage the values through the spin button, not by user input to the text boxes.

Hello StringJazzer...

Thank you very much...!

I would like to give you some money to take a beer on me.

Please give me a link for the payment.

Thank you very much again!

OneSurya, thank you very much for your kind offer. I provide help here as a community service and also to learn new things myself. I do not accept online payment for help I offer here, although if I am ever in Cyprus I will come to collect personally!

If you have problems that are complex, urgent, and important, we do offer a commercial services forum where you can offer payment to solve a problem.