+ Reply to Thread
Results 1 to 2 of 2

Prevent Shrinking UserForm Too Many Times

  1. #1
    Registered User
    Join Date
    03-13-2008
    Posts
    52

    Unhappy Prevent Shrinking UserForm Too Many Times

    I have a UserForm which can be shrunk using an image control which uses the following code:

    Please Login or Register  to view this content.
    How could I prevent this from being clicked more than twice as this obviously hides the UserForm and I have disabled the use of the X on the top right of the UserForm which means the user has no way of getting back to the full UserForm?

    I'm not too good at VBA code, I'm still learning but I tried:

    Please Login or Register  to view this content.
    ...but that doesn't get me anywhere, the user can still shrink it until only the titlebar is visible.

    EDIT - Also, if possible how could I change the colour of the text in a Label once the Image to reduce the size of the UserForm has been clicked more than once? Due to a background image on my UserForm the text labels next to the image to shrink/go back to full size blend in with the background and aren't very readable.

    Anyone got any ideas?

    ~Liam
    Last edited by LiamPotter; 03-27-2008 at 05:47 AM.

  2. #2
    Registered User
    Join Date
    03-13-2008
    Posts
    52
    Sorry for the inconvenience however I've solved the problem - just needed a bit of logical and common sense to put dWidth * 0.125 instead of Me.Height!!

    Please Login or Register  to view this content.
    ~Liam
    Last edited by LiamPotter; 03-27-2008 at 09:28 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1