title: vba , Autofill userform from another workbook cell selection
body: <p>I have a workbook that used to be one with many sheets, I have now split the sheet to different workbooks.</p>
  
  <p>The problem I now have is userform population from cell selection. When all the sheets were together. This code worked great.</p>
  
  <pre><code>Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  
  If Not (UFMJobSelectForm.ActiveControl Is Nothing) Then
      Call UpdateJobSelectForm
  End If
  End Sub
  </code></pre>
  
  <p>However now the Userform is in one workbook and this code is in another. I don't want to reference library as I need it to open and close so it can be accessed for other people to use.</p>
  
  <p>Thanks for any help in advance.</p>
  
  <p>Edit:
  What i have is 4 different workbooks with jobs on and i want to select the job and the userform populates with job details.</p>
  
  <p>The code I have detects the userform is open and then calls then populates the userform using updatejobselectform. Which worked when all the sheets were in the same workbook. however no longer works now i have separated them.</p>
  
  <p>When i run this code now the sheets are in there own work books i get Error: runtime erroe 424 object required.</p>
  
  <p>So what i am asking is dose anyone know how i can check a userform is loaded from in a different workbook and how i can get the useform to interact with cell selection from a different workbook.</p>
  
  <p>thanks again.</p>