View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brad Wylie Brad Wylie is offline
external usenet poster
 
Posts: 9
Default Excel 2007 Forms

It appears Excel 2003 and Excel 2007 put the user forms in a separate module
from the modules that excute code in the workbook.
In Excel 2003 I had code that referenced the form via UserForm.show in the
main startup module . This code generates an error in Excel 2007. Also
calls to subroutines in the code behind the form from the other modules
generates and undefined error. How does Excel 2007 link these two modules
now so that one can reference items in them.

Thanks
Brad Wylie