title: Calling Value From another macro
body: <p>I have a userform which opens one of a list of worksheets. I want to create a macro that recognises the last sheet opened by the userform and then runs data validation based on data types in the sheet.</p>
  
  <p>How can I reference the sheet opened so that it can be called later my the validation macro? </p>
  
  <p>All help gratefully accepted!</p>