+ Reply to Thread
Results 1 to 7 of 7

How to insert image on cell value base and auto fit in selected cell.

  1. #1
    Registered User
    Join Date
    01-14-2017
    Location
    Pakistan
    MS-Off Ver
    Ms Office 2016
    Posts
    35

    How to insert image on cell value base and auto fit in selected cell.

    Hello everyone,

    I am a beginer of excel VBA. I have creat a "Employees entrance data sheet" and also including Employee recruitment form...
    I have completed all things. But there is a problem to set picture in merged cells.
    Please see attached file and kindly help me as you think best..
    I am very thankful for all , who interested in...

    First of all kindly unzip the folder then check macro enabled file..



    Thanks
    Attached Files Attached Files
    "M. Shahbaz Anwar Advocate"

  2. #2
    Registered User
    Join Date
    01-14-2017
    Location
    Pakistan
    MS-Off Ver
    Ms Office 2016
    Posts
    35
    Anyone please help to slve this problem...
    Thanks

  3. #3
    Registered User
    Join Date
    01-14-2017
    Location
    Pakistan
    MS-Off Ver
    Ms Office 2016
    Posts
    35

    Re: How to insert image on cell value base and auto fit in selected cell.

    Only VBA Experts can solve my thread............

  4. #4
    Forum Contributor banaanas's Avatar
    Join Date
    08-26-2014
    Location
    Finland
    MS-Off Ver
    2016
    Posts
    199

    Re: How to insert image on cell value base and auto fit in selected cell.

    Hey!

    Try this:
    Please Login or Register  to view this content.
    Tuomas "Banaanas" Savonius
    Trying to give back now when I actually can do some VBA

  5. #5
    Registered User
    Join Date
    01-14-2017
    Location
    Pakistan
    MS-Off Ver
    Ms Office 2016
    Posts
    35

    Re: How to insert image on cell value base and auto fit in selected cell.

    Thanks sir, Mr, "banaanas ",
    This is working very good, But please add one thing more in this VBA code,
    That is "If i delete of remove code in Cell "c7", then picture should be removed or deleted, On the entry of new code in "C7", previous image should be removed",

    By the thanks for helping me...

  6. #6
    Forum Contributor banaanas's Avatar
    Join Date
    08-26-2014
    Location
    Finland
    MS-Off Ver
    2016
    Posts
    199

    Re: How to insert image on cell value base and auto fit in selected cell.

    Modified:
    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    01-14-2017
    Location
    Pakistan
    MS-Off Ver
    Ms Office 2016
    Posts
    35

    Re: How to insert image on cell value base and auto fit in selected cell.

    Thanks your sir,,,
    For great effort.....

+ 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] Insert the first image found with image search (e.g google) with criteria taken from cell.
    By themob212 in forum Excel Programming / VBA / Macros
    Replies: 31
    Last Post: 04-14-2021, 12:29 PM
  2. Insert Image With Image Filename In Another Cell - Excel
    By Angelq117 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-17-2016, 09:38 AM
  3. Macro to insert image in cell based on cell value
    By jwillis07 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-06-2015, 12:50 PM
  4. Insert image and resize to fit merges selected cell (also merged cell)
    By acecarwash in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-14-2014, 09:55 AM
  5. Replies: 2
    Last Post: 03-31-2014, 01:32 AM
  6. [SOLVED] Linking Image to a cell value, and display the selected image in new sheet
    By siva venkata in forum Excel General
    Replies: 12
    Last Post: 03-25-2014, 02:34 AM
  7. Insert Image to adjacent cell, not predefined cell
    By tshrader in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-05-2013, 10:50 AM

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