Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Nov 2002
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Edit sheet with userform open

    Reading another thread I cam across a user who wanted to be able to edit a sheet with a userform open. Apparently you cant do this because userforms are opened modaly. It is possible to open them non modaly. I've never heard of the term 'Modal' before. Could anyone expand a little?

  2. #2
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Edit sheet with userform open

    In Excel 2000, a userform can be modeless:

    Userform.Show vbModeless

    This is a new feature of Excel 2000.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •