Consulting

Results 1 to 7 of 7

Thread: Forms always visible

  1. #1
    VBAX Newbie
    Joined
    Oct 2013
    Posts
    4
    Location

    Forms always visible

    good day I created a form I would like to know the command to keep it always visible, let the spreadsheet attached thanks
    Attached Files Attached Files

  2. #2
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,814
    Location
    I am moving this thread to the Excel Forum.

    Please take the time to read the Forum FAQ link in my signature.

    Thank you.
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

  3. #3
    VBAX Newbie
    Joined
    Oct 2013
    Posts
    4
    Location
    sorry for posting in the wrong place, I'm trying to make is that the form I created, it closes the form and have no option to open again, I would have to create another button? I do not know if I'm asking this field correctly or if I should go to another place from what I understand I have been moved from where I was ereei anticipate my apologies again, grateful

  4. #4
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,814
    Location
    In VBA, Use the View Menu to show the Properties window. Click on the UserForm background and set the ShowModal property to "False."
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

  5. #5
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,711
    Location
    another way

    Option Explicit
    
    Private Sub Workbook_Open()
        Call UserForm1.Show(vbModeless)
    End Sub

    Paul

  6. #6
    VBAX Newbie
    Joined
    Oct 2013
    Posts
    4
    Location
    Paul thank you very much, that was really needed

  7. #7
    VBAX Newbie
    Joined
    Oct 2013
    Posts
    4
    Location
    Thanks for the feedback, helped me to improve my knowledge

Posting Permissions

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