Thread: userforms
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default userforms

If the other workbook is open, then you can display a userform from the
other workbook using "Application.Run..." to call the sub in the other
workbook that shows the form...

Sub ShowTheOtherForm()
Application.Run "OtherBook.xls!OtherRoutine"
End Sub


"Zaahir"
wrote in message
hi
can i open a userform located on a different workbook?
Regards