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 in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...
Top