+ Reply to Thread
Results 1 to 3 of 3

Different image in excel worksheet based on date

  1. #1
    Forum Contributor
    Join Date
    06-30-2018
    Location
    Sweden
    MS-Off Ver
    2016.
    Posts
    397

    Different image in excel worksheet based on date

    Hi,

    how can I show different images in an excel worksheet depending on what day it is? Or use a random image everytime a worksheet is opened?

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,523

    Re: Different image in excel worksheet based on date

    Here is a thread from 10 years ago, that describes it quite well.
    https://www.excelforum.com/excel-gen...combo-box.html

    See attached, when the date changes in A1 the picture will change, the pictures are located in sheet "Images" and if you select the cell that is under the pictures, you will see they are named acording to the day, IE: PicMonday, PicTuesday, ect...
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    06-30-2018
    Location
    Sweden
    MS-Off Ver
    2016.
    Posts
    397

    Re: Different image in excel worksheet based on date

    Thank you for your answer!

+ 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. Replies: 0
    Last Post: 09-04-2016, 11:47 PM
  2. [SOLVED] VBA to transfer image FROM userform image control TO a worksheet cell
    By Zoediak in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2014, 02:51 PM
  3. Automatically create Gmail with text, based on date entry in Excel worksheet
    By F1Fan in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-17-2012, 12:17 PM
  4. Excel VBA find newest worksheet based on date/time stamp in worksheet name?
    By takchin.tc in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-27-2012, 03:56 PM
  5. Display Image Based On Image Name In Cell
    By processchip in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2011, 10:11 AM
  6. How to append worksheet into one excel file based on date
    By jopanda25 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-18-2010, 12:32 PM
  7. [SOLVED] Hyperlink to an image in other worksheet, displaying entire image.
    By twilliams in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-07-2006, 06:10 PM

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