Consulting

Results 1 to 8 of 8

Thread: Solved: Minimize user form

  1. #1

    Solved: Minimize user form

    Hi - was wondering if theres any way to minimise a user form?

    I have a command button that closes/hides the form but can a cmdbutton be used to minimise to tray?

    thanks

  2. #2
    Found this but doesn't min to tray

    Private Sub ToggleButton1_Click()
    If ToggleButton1.Value = True Then
    Me.Height = Me.Height * 0.25
    Else
    Me.Height = dHeight
    End If
    End Sub

    Private Sub UserForm_Initialize()
    dHeight = Me.Height
    End Sub

  3. #3
    VBAX Mentor asingh's Avatar
    Joined
    Jul 2005
    Posts
    307
    Location
    Hi,

    I had used a solution from here..the form would minimize to the bottom..!

    regards,

    asingh

  4. #4
    Thanks - seen that but its a little complicated to see what bits I need for
    my own project. I did try but kept getting 'can't execute break in code' errors.

  5. #5
    VBAX Mentor asingh's Avatar
    Joined
    Jul 2005
    Posts
    307
    Location
    post your workbook....can integrate it for your form. Specify on which forms you want the minimize functionality...?

  6. #6
    Unfortunately the file is bigger than the limit of 241Kbs

    thanks for the offer anyways

  7. #7
    I'll mark as solved

  8. #8
    VBAX Contributor Ivan F Moala's Avatar
    Joined
    May 2004
    Location
    Auckland New Zealand
    Posts
    185
    Location
    Is it solved ?

    Specifically what did you get stuck on ?
    If you can send me the work book then perhaps I can help
    Kind Regards,
    Ivan F Moala From the City of Sails

Posting Permissions

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