Variable accross form to module
I have the below code, which is working perfactly for me.
However, I want to move the 'Sub Event_Date' from the userform to the actual module.
what ammendments do I need to consider rather than just doing a cut and paste on the code?
Cheers guys
Please Login or Register to view this content.
That doesn't appear to make any sense since the sub just checks if two textboxes are filled in. Why do you want to move it out of the form's code module?
Everyone who confuses correlation and causation ends up dead.
I have the Assign Paths to Variable code with in the module, Ive included that below.
I want to move all subs from the UserForm and leave it as a script of Call commands if at all possible.
Please Login or Register to view this content.
All I can see that achieving is creating a need for public variables (which is bad), unless you rewrite all your code. If you want to separate logic from interface (which is a good aim) your button click should call one routine and pass it all the variables required from the form. The called routine should then call the other routines passing local variables as required.
Cheers for the advice, I think I'll give it a shot!
For the record, I would keep the validation of the textboxes in the form's code:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks