View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Nigel[_2_] Nigel[_2_] is offline
external usenet poster
 
Posts: 735
Default vbApplication-NOT-Modal

By default user forms open modal, so use the following method to open it
non-modal

UserForm1.Show (0)

--

Regards,
Nigel




"k1sr" wrote in message
...
Hi Dave,

It still seems to be modal - I'm not familiar with User Forms - do I bring
up the User From simply with UserForm1.Show or is there another way, as
this
way leaves me still unable to use other excell worksheets...

cheers