| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing Excel 2007 Userforms from Macros
In Excel 2003 I could access my user form from the macro running in an an
Excel worksheet using frmPayrollForm.show. In Excel 2007 this same statement creates a "subscript out of range" error message. Also when accessing subroutines in the userform code from the macro it creates an error message "sub or function not defined" error message. The form has to be accessed from the spreadsheet to start so how does Excel 2007 link these two folders together so the form is accessable. -- Brad Wylie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Anyway of accessing the internet from within excel 2007? | Excel Discussion (Misc queries) | |||
| Accessing Excel Macros from VB.Net | Excel Programming | |||
| Accessing Web Service in the Excel 2007 | Excel Programming | |||
| accessing .mpp file using excel VBA macros | Excel Programming | |||
| excel 2002 -Userforms and macros help | Excel Programming | |||
Threaded Mode
