| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserForm1.show fails if another workbook is open
If I have two excel files (both with VBA applications) open and I am running
VBA application from one of them, when I try to do User1.show, it fails. I get a Run Time error 9. Subscript out of range. However if I close the application I am not using at the moment the User1.Show works as expected. Any help would be appreciated, Gary |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel VB - show userform1 (at same time) minimized application win | Excel Discussion (Misc queries) | |||
| VBA + VB Script fails to open the workbook. | Excel Programming | |||
| Workbook fails to open - Excel 2003 | Excel Discussion (Misc queries) | |||
| Excel fails to open workbook using Automation from VB 6 | Excel Programming | |||
| SetFocus to first textbox on userform upon Userform1.Show | Excel Programming | |||
Threaded Mode
