View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mats Samson Mats Samson is offline
external usenet poster
 
Posts: 112
Default Call UserForm procedures from another workbook

Is it possible to Run a Userform.Show and call/run a procedure in the
Userform from another active workbook once the form is loaded but hidden.
I'm switching from the Userform to the "data" workbook, selects the data to
copy and press a button to copy & paste, switching back to the Userform and
continues to manipulate the data. I can do it with starting a procedure in a
module in the same workbook as the userform but I'd like to jump directly
back to the Userform.