View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\)[_2378_] Rick Rothstein \(MVP - VB\)[_2378_] is offline
external usenet poster
 
Posts: 1
Default vbApplication-NOT-Modal

You can make a UserForm non-modal by using this statement to initially show
it...

UserForm1.Show vbModeless

Substitute the name of your actual UserForm for the example name UserForm1
that I used.

Rick


"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