Excel - VBA : pass variable from Sub to Userform (Date Picker) Part II

You'd use a class, but we'd need to see an example of how you're calling these forms along with a couple of forms. Could you upload a workbook?

Thanks, Kyle. That's what I sort of suspected. I've decided to go another direction with it.

Ok, you realise it'll only be a couple of lines of code though right?

here's a sample. I tried removing the module and directly inserting it into the click event, but their is some connection to the function, so it errors out. If you've got any ideas, I'm all for that.

The easiest way is to simply turn your sub into a function:

Please Login or Register  to view this content.

Then in userform1:

Please Login or Register  to view this content.

Userform1 and 2 shouldn't be different userforms either - you should be using the same one

@bakerman2 you wouldn't if you want the datepicker in multiple places though with the same config

Indeed, but it makes it less portable. As it stands the useform is both portable and configurable, moving configuration into the calendar userform limits these options without faffing on future projects.

Not wanting to change them is an argument for putting the config somewhere else and follows DRY principles - that's why I suggested calling the DatePicker function from a module - the config will be the same regardless of what is calling it

Their different forms because there are a number of forms for different tables that require date inputs. That was simply the mockup to see if different subs could call the same routine.

Kyle123 - It works on different forms. Awesome. Thanks for the code!