Thread: UserForm1.show fails if another workbook is open
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gary Gary is offline
external usenet poster
  
Posts: 273
Default 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

Reply With QuoteReply With Quote