View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Starting Userform

Hi Mats,

One way:

In Book1:

Sub MyUserform
Userform1.Show
End Sub

Hide Book1

'====================

In Book2:

Sub Test
Application.Run "Book2!MyUserform"
End Sub


---
Regards,
Norman



"Mats Samson" wrote in message
...
Can I start a UserForm from another workbook and eventually even
have the workbook with the UserForm hidden?
Regards
Mats