+ Reply to Thread
Results 1 to 2 of 2

Cells/data boxes over pictures

  1. #1
    Registered User
    Join Date
    01-17-2019
    Location
    Scotland
    MS-Off Ver
    365
    Posts
    81

    Cells/data boxes over pictures

    Hi,

    This may be incredibly simple and it is distinctly possible I'm just being dim but bear with me

    I have a form (I cant post due to the content) I am looking to populate for printing an would like to auto fill. There are a bunch of graphics on it I cant get the originals for so cant just rebuild without a hell of a lot of drawing. I have tried dropping picture as a background but I get a tiled version (i.e. a bunch of the same picture as tiles) rather than one picture I can try to line up rows/columns to.

    My preferred option would be to draw in cells on top of a normally inserted picture (like you would insert a text box) and reference them to data but a regular text box doesn't seem to allow a reference to another cell and I cant find another option that does. Anyone know of a way to do this?

    My fall back is to find a way to drop a single (a4) into the background so that I can try to line up the rows columns (removing the row column lines) and overwriting the picture at the points a need the data in. The problem with this is I can either insert the picture but the cells are behind the picture (even after send to back as this is only about picture order) or insert picture as a background which gives me a 'tiled' effect.

    Does anyone know a way to do this or do I have to get drawing up some line-art

  2. #2
    Forum Contributor
    Join Date
    12-30-2021
    Location
    Mount Gambier, Australia
    MS-Off Ver
    Microsoft Office Home and Student 2019
    Posts
    117

    Re: Cells/data boxes over pictures

    you can copy the file and change data to generic.

    I think it sounds like you want a watermark.

    See here
    HTML Code: 
    it shows how to make one in excel.

+ 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: 6
    Last Post: 07-09-2018, 10:43 AM
  2. [SOLVED] Userform to show pictures in cells & data in other cells in the row
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-07-2015, 05:41 AM
  3. Active X text boxes on my sheet are being recognized as pictures?
    By mdovey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-23-2014, 03:15 PM
  4. [SOLVED] Delete mass pictures and check boxes in a column
    By SimonsGE in forum Excel General
    Replies: 3
    Last Post: 04-10-2013, 08:20 PM
  5. Replies: 4
    Last Post: 06-07-2012, 10:11 AM
  6. Pictures/Text Boxes not the size specified
    By dsievers71 in forum Excel General
    Replies: 4
    Last Post: 02-23-2007, 08:42 PM
  7. Pictures with Data from Exel-Cells
    By xirx in forum Excel General
    Replies: 4
    Last Post: 07-08-2005, 09:05 AM

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