I have a listbox populated with the 12 months and under the "OK" button I increase the selected value by 1, so if they've clicked on January it stores "1", June it stores "6", etc. There is also a spinbutton and textbox where I have "2014" and lets the user increase this by one.
How do I pass this numbers from the listbox and textbox to a sub in module 1? I have a sub that opens a workbook and I need the date to figure out which workbook to open. The workbook is named in the same basic format each month of "2014-05" for May 2014.
I've tried making the sub in the userform public, naming the varaibles public and just can't figure it out.
Bookmarks