+ Reply to Thread
Results 1 to 2 of 2

zoom userform

  1. #1
    Registered User
    Join Date
    04-28-2009
    Location
    UK
    MS-Off Ver
    Excel 2000
    Posts
    38

    zoom userform

    In Excel 2000 there's a control on the userforms toolbar which zooms the form while in design mode. I've got two questions about this:

    1. The zoom control resizes all the fields buttons etc. on the form, but doesn't resize the form itself. So items can fall off the edge when enlarged. Not very clever! Is there a way round it, other than resizing the form manually?

    2. Is there a way of letting the user resize the form, including the controls on the form? Would be very helpful because the form can appear very different sizes on different PCs.

    Thanks in advance for your help,
    David

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: zoom userform

    You could try this coded solution
    http://www.andypope.info/vba/Anchor.htm
    Cheers
    Andy
    www.andypope.info

+ 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