Results 1 to 3 of 3

Thread: Shapes

  1. #1
    Acolyte Heyjoe's Avatar
    Join Date
    Jan 2019
    Location
    USA
    Posts
    55
    Articles
    0
    Excel Version
    2019

    Question Shapes



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello everyone,

    I have excel 2019.

    I have 3 shapes on sheet 1 of my workbook. There are a triangle, a square and circle. To put these shapes in the workbook I I went to insert illustrations, then shapes.


    Is there a way to convert a shape to text so that I can use a simple = formula to get the shape in cell a1 of sheet 2? I think the answer is no. Would you agree that VBA would be necessary to get the shape into cell a1 of sheet 2?

    I used the macro recorder to find some code but I would prefer to use a formula if possible.
    Last edited by Pecoflyer; 2019-03-17 at 08:36 AM. Reason: Moved to correct forum

  2. #2
    Conjurer Kenneth Hobson's Avatar
    Join Date
    Mar 2014
    Location
    Tecumseh, OK
    Posts
    135
    Articles
    0
    Excel Version
    365
    No, formula's return a result. They don't manipulate objects.

    One can use VBA to look for a sheet cell(s) change event and act accordingly.

  3. #3
    Acolyte Heyjoe's Avatar
    Join Date
    Jan 2019
    Location
    USA
    Posts
    55
    Articles
    0
    Excel Version
    2019
    Thank you Kenneth. I found a custom paste that can link pictures. This solved my problem.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •