Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Vancouver, Canada
    Posts
    131
    Thanks
    0
    Thanked 0 Times in 0 Posts

    VBA UserForms (Excel 2000)

    Does anyone know how to size a picture on a UserForm? I'm trying to put our logo onto a dialog box I've created and it's HUGE. I can't figure out how to make it smaller since there are no sizing handles as there are with pictures in a spreadsheet.

    Thanks in advance,

    Christa

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: VBA UserForms (Excel 2000)

    Probably your best bet is to load the logo into MS Photo Editor or some similar bitmap editor (assuming it is a bitmap) and re-size it there. The size is often determined by the dpi (dots per inch), so the first thing you could could is to reduce that to 96dpi (that is the normal for screen display), and if that does not reduce the dimensions enough, you can resize the picture dimensions in the bitmap editor.

    Reszising the source image is the best as it will reduce the size of your project.

    Hope that helps

    Andrew C

  3. #3
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Vancouver, Canada
    Posts
    131
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA UserForms (Excel 2000)

    Thanks, Andrew...I appreciate the help <img src=/S/groovin.gif border=0 alt=groovin width=21 height=21>

  4. #4
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA UserForms (Excel 2000)

    Andrew is correct about including a large picture in your project.

    However, if you have something that is around the same size, and you only want to make small changes (or if you want to make a picture larger), set the PictureSizeMode propert on the image control. By default, it's set to 0, which doesn't allow resizing.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

Posting Permissions

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