Passing Userform Vairiable to Main Module

[MAM8433]

Right now, my macro starts Module1 [Sub simpleXlsMerger()], which opens a userform that collects start and end dates using 2 datepicker controls. The dates are collected in another sub procedure [Private Sub CmdOK_Click()]. How do I pass these dates back to Module1? I’ve read that I need to use “public” instead of Dim, but it doesn’t work with Subs. Instead, I get the message, “Invalid attribute in Sub or Function.”

What changes can I make to pass these dates back to Module1? And where do the Public variable declarations go? In Module1 or CmOK_Click()? Thank you. I hope you can help.

 

[MAM8433]

LOL. I compared my code. The problem was fixed by changing StartDate.value=U.StartDate to StartDate = U.StartDate. Thank you so much, VBA Geek, for helping to learn more VBA!