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...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top