How do I pass data input on userform back to calling module?
Posted on 2010-08-18
I hope someone can help me. I have created (or more aptly, cobbled together!) a macro in Outlook that, having done various things then calls a user form for the user to enter data. What I'm now stuck on is how to pass that collected data back into the calling macro to do more stuff with. I have tried to find a solution to what must be a basic VB activity, but have failed miserably so far. Could someone please explain in simple terms the process required?