Open a userform of one spread sheet with another spread sheet
I am wondering how I can open "userform16" from a spread sheet called
"NPI data entry form" with another spread sheet called "TEAH entry" Both sheets would be open |
Open a userform of one spread sheet with another spread sheet
one way. in the workbook with the userform, i used a workbook named weekly.xls:
Sub test2() UserForm16.Show End Sub then in the other workbook Sub test() Application.Run "Weekly.xls!test2" End Sub -- Gary wrote in message ... I am wondering how I can open "userform16" from a spread sheet called "NPI data entry form" with another spread sheet called "TEAH entry" Both sheets would be open |
Open a userform of one spread sheet with another spread sheet
On Aug 8, 5:22*pm, "Gary Keramidas" <GKeramidasATmsn.com wrote:
one way. in the workbook with the userform, i used a workbook named weekly.xls: Sub test2() UserForm16.Show End Sub then in the other workbook Sub test() Application.Run "Weekly.xls!test2" End Sub -- Gary wrote in message ... I am wondering how I can open "userform16" from a spread sheet called "NPI data entry form" with another spread sheet called "TEAH entry" Both sheets would be open- Hide quoted text - - Show quoted text - If I run the macro to run the userform from the same spread sheet it works but if I run the macro that runs the macro I get a subscript out of range error |
Open a userform of one spread sheet with another spread sheet
not sure what's going on without seeing it.
-- Gary wrote in message ... On Aug 8, 5:22 pm, "Gary Keramidas" <GKeramidasATmsn.com wrote: one way. in the workbook with the userform, i used a workbook named weekly.xls: Sub test2() UserForm16.Show End Sub then in the other workbook Sub test() Application.Run "Weekly.xls!test2" End Sub -- Gary wrote in message ... I am wondering how I can open "userform16" from a spread sheet called "NPI data entry form" with another spread sheet called "TEAH entry" Both sheets would be open- Hide quoted text - - Show quoted text - If I run the macro to run the userform from the same spread sheet it works but if I run the macro that runs the macro I get a subscript out of range error |
Open a userform of one spread sheet with another spread sheet
when i use this:
Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.Run "NPI data entry form.xls!Macro1" End Sub it says it cannot find the macro when i use this Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.Run "'NPI data entry form.xls'!Macro1" End Sub i get subcript out of range |
Open a userform of one spread sheet with another spread sheet
I got it working
Thanks |
Open a userform of one spread sheet with another spread sheet
ok, good to hear.
-- Gary wrote in message ... I got it working Thanks |
All times are GMT +1. The time now is 12:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com