How to pass a variable value from a Userform listbox/spinbutton to another sub

Sorry but this is an incomplete description:

under the "OK" button I increase the selected value by 1, so if they've clicked on January it stores "1",

Increase what selected value? Stores it where?

naming the varaibles public

What variables? You haven't said anything about variables in your description.

Based on what you have described, there are two ways to do this. The simplest is to refer to the listbox and textbox in the sub. You don't give the name of your form so I'm going to call it UserForm1, and so on for the other objects.

Please Login or Register  to view this content.

The other more complicated way is to declare public variables in your UserForm code, and assign them as above when the user clicks OK. Then refer to those variables in the other Sub. This breaks the dependency so that Module1 no longer has to know how UserForm1 has implemented the controls (which is an advantage).

Please Login or Register  to view this content.

Why not open the workbook(s) with code in the userform?