+ Reply to Thread
Results 1 to 2 of 2

Form to display multiple pictures for user select (w dynamic resize & position at runtime)

  1. #1
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Form to display multiple pictures for user select (w dynamic resize & position at runtime)

    I'm trying to do something that has several requirements - each of which should be fairly simple by themself - but I need some help to sort out these out and tie them together - especially the resizing and screen size aspects.


    Background (Optional/Can skip reading this bit)
    I have a hobby project I have been playing with for years. One of its sub tasks is to display certain images from a directory to be reviewed and have an option selected. I have refined this form code and I'm happy with how it works. Lately I have been feeling frustrated at how slow it is to review images one by one so I decided to jump into the deep end and have a userform display several images at once to allow multiple selections. But most of the code I was using for displaying a single image is impractical for displaying multiple images.


    Design Plan
    1. Create a user form with 8 frames and 8 checkboxes (frames to display pictures, checkboxes to indicate choices) = DONE
    2. Write module code and form properties to pass an array of 8 image filenames = INCOMPLETE. But I think I am capable of handling this
    3. To make it easy to see the images, I want the frames to dynamically resize + position at runtime to have the frames take up as much form space as possible (without overlapping other frames or the checkbox controls) = INCOMPLETE
    4. But to create maximum form space, I want the form to dynamically resize at runtime to almost fill the screen (If user has more than one screen, only fill the main monitor)= ALMOST THERE After mixing code found on the web, I have this almost completed. I would like to make this 64 bit compatible
    5. Have code (with accelerators) for user to indicate which picture/s need to have an action applied = INCOMPLETE. But I think I am capable of handling this
    6. Write form properties to return the users choices from the checkboxes = INCOMPLETE. But I think I am capable of handling this

    So I mainly need help with the resizing - points 3 & 4. Can anybody help out please?
    Last edited by mc84excel; 03-24-2019 at 05:31 PM. Reason: thread solved. removed obsolete attachment
    *******************************************************

    HELP WANTED! (Links to Forum threads)
    Trying to create reusable code for Custom Events at Workbook (not Application) level

    *******************************************************

  2. #2
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Re: Form to display multiple pictures for user select (w dynamic resize & position at runt

    nvm. After several hours research & design, I have achieved the main goals for this thread so I am marking it solved.

    For the next developments to this concept of 'end user reviews/selects images from multi selection', see the following threads:

    Make this form compatible with 64 bit Excel
    Image pop up upon mouse hover over form image
    Last edited by mc84excel; 03-24-2019 at 05:29 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Resize Multiple Pictures in cell With Result Must Same Size [4 pict)
    By Jhon Mustofa in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-01-2019, 01:59 AM
  2. Creating dynamic userform rely on dynamic checkbox selection
    By END93 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-17-2016, 06:39 PM
  3. Dynamic Range, based on user selection, used with FOR LOOP
    By ericbartha in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-01-2015, 05:08 PM
  4. [SOLVED] Loading pictures into userform as per selection vba
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-05-2014, 07:39 PM
  5. Userform user selection
    By Specialist in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-03-2013, 05:42 AM
  6. Dynamic Pie Chart Based on User Selection
    By mcollins789 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-03-2013, 06:17 PM
  7. Copy and Resize Multiple Pictures then paste
    By Hlowmaster in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-22-2011, 05:53 PM

Tags for this Thread

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