+ Reply to Thread
Results 1 to 7 of 7

Picture of "camera" as background of a cell comment

  1. #1
    Registered User
    Join Date
    12-25-2017
    Location
    Switzerland
    MS-Off Ver
    2016
    Posts
    25

    Question Picture of "camera" as background of a cell comment

    Hello,

    I know how to define a picture as background of a cell comment.

    I intend to define the content of the excel camera as this backround picture; thus, it should be a "dynamic picture" as generated by the camera.

    Can anybody help me?

    Thanks a lot for every hint.

    Florian

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Picture of "camera" as background of a cell comment

    I presume you are referring to the very useful but often forgotten about 'Camera' in the Customise Quick Access Toolbar options
    Mine is shown in the right hand pane since I've alreadt dragged it across.


    QAT - Camera.JPG
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Picture of "camera" as background of a cell comment

    I am not sure if it is possible to make the image in comment box a linked camera image, but here is something similar
    - camera image is named "Picture 2"
    - select cell A10 and the image appears
    - select any other cell and it disappears
    - test in attached workbook

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by kev_; 02-19-2018 at 06:12 PM.
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

  4. #4
    Registered User
    Join Date
    12-25-2017
    Location
    Switzerland
    MS-Off Ver
    2016
    Posts
    25

    Re: Picture of "camera" as background of a cell comment

    Dear both,

    thank you very much for your replies.

    My target is that I format a cell comment: Colors and Lines - Fill Colore - More fill effects - picture.
    And the picture that I choose here should be the one that I prepared by applying the camera tool. But this picture doesn't have a name and is not choosable, respectively.
    Thus, I am looking for a work around.

    Florian

  5. #5
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Picture of "camera" as background of a cell comment

    My suggestion is your workaround

  6. #6
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Picture of "camera" as background of a cell comment

    I have played around with this for you and it now reacts when you hover over the cell
    - test in attached file

    HOVER over LEFT side of A10, the camera picture is displayed

    Hover LEFT.jpg

    HOVER over RIGHT side of A10, the camera picture is hidden

    Hover RIGHT.jpg

    Click on cell A10 to edit value in the cell

    This efffect is created by using 2 Active-X Labels (each label is half the width of the cell), placing them over cell A10, making them transparent, and using MouseOver event to Hide\Unhide picture
    Label Click event used to enable cell editing
    Attached Files Attached Files
    Last edited by kev_; 02-20-2018 at 05:30 AM.

  7. #7
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Picture of "camera" as background of a cell comment

    Another variation
    - this most ressembles behaviour of comment box
    - hovering over the centre of A10 displays the camera picture
    - see attached file
    Attached Files Attached Files
    Last edited by kev_; 02-20-2018 at 05:31 AM.

+ 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. Add date/time stamp to comment when cell is marked "X"
    By msaric in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-28-2016, 07:31 AM
  2. [SOLVED] Display Picture "A" or Picture "B" based on value in Cell A1
    By JET2011 in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 09-18-2015, 06:53 PM
  3. Cells().Select and .Activate don't "move the camera" to that cell - how do I do this?
    By lordterrin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-08-2014, 03:00 PM
  4. VBA to insert pictures to " insert comment " or "Text box" in cell E5 and E15
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-20-2013, 08:10 PM
  5. Replies: 0
    Last Post: 06-25-2013, 10:44 AM
  6. Creating uncalculated "Background/Greyed out" txt and values in a cell
    By Vectra_Condor05 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-13-2013, 09:45 AM
  7. Replies: 4
    Last Post: 07-09-2012, 04:32 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