shapes cell reference

  1. G

    [VBA] Delete shapes with values

    I have about 20 sheets, each with about 400 shapes (rounded rectangles). These shape values (ex. "=A32", "=B12", "=E24") are referencing 8 columns and 50 rows in the sheet. These referenced cells are using INDIRECT to pull data from another sheet, which is using IFERROR(INDEX..., so there is...
  2. T

    VBA Make Existing Shape Extend to Certain Cell

    Hi there I'm very new to vba and I was wondering if it were possible to lengthen an existing shape for example rectangle from C2:E2, and have it go from C2:G2 by clicking a command button? I'm attempting to create a 1 year look ahead with arrows stretching from the first month on the schedule...
  3. S

    Conditional formatting of a group of text boxes.

    Hi, I am using around 200 individual text boxes in a single worksheet that each contain a formula pointing to the value of a unique cell in another worksheet in the same workbook. Each cell being referenced contains a numeric value. I wish to apply conditional formatting to the value in the...
  4. J

    Conditional Formatting Inserted Object without VBA?

    Guys, I did a search on this subject, but didn't find a great answer. Please see the illustration below. I have inserted the U.S. map in a spreadsheet, and want to change the color of each state based on its recovery %. I know how to label each state with the amount from each cell, but...
  5. D

    Automatically bringing a Shape into a Cell Using Shape Code

    Hi Guys, I am preparing a Bar Bending Schedule sheet. I have shape codes and each shape code for each shape. I will be entering the shape code in a cell and excel should automatically find the shape and bring the shape in another cell. Consider a "L" shape drawn using shapes. Here we need...
  6. M

    Stack Column and Shapes in Excel

    Hi All, I am not able to work on the Stack Column Chart in VBA. One main reason i understood from the debug was its not able to reference to particular chart when it becomes active. Help on this would be very much appreciated. And second aspect is if there is any workaround in working out...
  7. S

    Update Cell Reference within a shape

    I am currently using rectangles within a single cell so I can have three difference colors in one cell (so let me know if there is an easier way to accomplish that). Each rectangle references a cell (A1, B1, C1) and fills up D1. When I copy cell D1 (which also selects the shapes) and paste...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top