• Edit sheet with userform open

    Author
    Topic
    #355022

    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?

    Viewing 0 reply threads
    Author
    Replies
    • #522881

      In Excel 2000, a userform can be modeless:

      Userform.Show vbModeless

      This is a new feature of Excel 2000.

    Viewing 0 reply threads
    Reply To: Edit sheet with userform open

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: