+ Reply to Thread
Results 1 to 8 of 8

Placement of a ‘Selected Picture’ on a GUI from a different ‘Worksheet of Pics’ with VBA

  1. #1
    Registered User
    Join Date
    11-26-2012
    Location
    Sri Lanka
    MS-Off Ver
    Excel 2013
    Posts
    35

    Placement of a ‘Selected Picture’ on a GUI from a different ‘Worksheet of Pics’ with VBA

    Hello My Friends: [Especially Forum Guru Andy Pope]

    I have a small / great problem!

    This Worksheet (Pics) has 78 Pictures:

    Pics.JPG

    This Worksheet below randomly selects a Picture from above: [in this case the Picture ‘Named’ 74.JPG]

    Raw.JPG

    I need the ‘Selected Picture’ to go into the Space / ActiveX Image Control using VBA Code on clicking a Button.

    GUI.JPG

    Could you please help me?

    Thanks in advance...
    Attached Files Attached Files
    Thanks a lot...

    - pd -

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Placement of a ‘Selected Picture’ on a GUI from a different ‘Worksheet of Pics’ with V

    Attach the workbook, not a PDF!!!
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    11-26-2012
    Location
    Sri Lanka
    MS-Off Ver
    Excel 2013
    Posts
    35

    Re: Placement of a ‘Selected Picture’ on a GUI from a different ‘Worksheet of Pics’ with V

    Thank you very much for the reply Madam...

    The File with its 77 pictures is 5.82 MB on the disk, way over the permissible limit for uploading an .xlsm file...

    Is there any other way I could get this to you, perhaps by sharing on Google Drive?

  4. #4
    Registered User
    Join Date
    11-26-2012
    Location
    Sri Lanka
    MS-Off Ver
    Excel 2013
    Posts
    35

    Re: Placement of a ‘Selected Picture’ on a GUI from a different ‘Worksheet of Pics’ with V

    Sorry, not 77 but 78 Pictures... and I would need your e-mail address to share the source file on the Google Drive...

    Thanks & Best Regards - pd

  5. #5
    Registered User
    Join Date
    11-26-2012
    Location
    Sri Lanka
    MS-Off Ver
    Excel 2013
    Posts
    35

    Re: Placement of a ‘Selected Picture’ on a GUI from a different ‘Worksheet of Pics’ with V

    When Reduced to .xlsb it still comes to over 5 MB

    I will make another copy, reduce the pictures to 6 and then upload the .xlsm file here...

    Thank you very much.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Placement of a ‘Selected Picture’ on a GUI from a different ‘Worksheet of Pics’ with V

    Yes, precisely - a cut-down version.

    I would need your e-mail address to share the source file on the Google Drive...
    No way, José!!!

  7. #7
    Registered User
    Join Date
    11-26-2012
    Location
    Sri Lanka
    MS-Off Ver
    Excel 2013
    Posts
    35

    Re: Placement of a ‘Selected Picture’ on a GUI from a different ‘Worksheet of Pics’ with V

    OK Josée... Will do that tomorrow...

  8. #8
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: Placement of a ‘Selected Picture’ on a GUI from a different ‘Worksheet of Pics’ with V

    (removed as too late, refresh issue)

+ 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. Click on picture and run macro to replace existing picture with selected picture file
    By houseflipsheet in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-14-2014, 12:02 AM
  2. Create Macro to Print Selected Section that may change in row placement from month to mont
    By Frenchqtrgirl in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-27-2013, 05:03 PM
  3. Need to delete all pics in a worksheet
    By moe171 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-21-2009, 04:50 AM
  4. Picture Resize/Placement Problems
    By LeechyEikichi in forum Excel General
    Replies: 0
    Last Post: 05-26-2007, 04:01 PM
  5. Checking for pics & deleting pics in Excel worksheet
    By karthikmg in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-16-2007, 10:44 AM
  6. [SOLVED] Picture Placement
    By pkenny in forum Excel General
    Replies: 1
    Last Post: 06-06-2006, 12:30 PM
  7. Picture Import Questions - Size and Placement
    By Shatin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-01-2005, 10:05 AM
  8. [SOLVED] Suppress double click behaviour when a picture on a worksheet is active/selected
    By David Cuthill in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-24-2005, 08:06 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