1. M

    Position and Resize Rectangles Dynamically, Based on Cell Values

    I've been working on this all day and have had zero success. I want to be able to change dates in Columns A and B and have rectangles position and lengthen themselves accordingly, based on the calculated values in Columns C and D. I almost had something working earlier today but it would only...
  2. A

    My delete picture code doesn't work

    Hi everyone, I used some codes to insert a picture in a sheet. Then later I want to delete it, but leave the command button. I tried 3 different codes but none of them works. This one doesn't do anything Dim Pic As Shape For Each Pic In ActiveSheet.Shapes If Pic.Type =...
  3. K

    Loop Shapes and Hide if Value/Text is Zero

    I am trying to create a sheet to print scales and chords for guitar students. I am having trouble hiding shapes on the fretboard based on the value within the shape. There are 224 shapes on the worksheet. Each shape is linked to it's own cell on a separate sheet. I figured out how to hide a...
  4. V

    Bug? Aligning Shapes to Cell dimensions is now not and exact match?

    Hi all, I have a macro that fills a textbox with a picture from a URL and aligns the textbox to a cell. Sub FillPic() Dim i As Long, URL As String Dim oTextBox As TextBox For Each oTextBox In ActiveSheet.TextBoxes oTextBox.Delete Next oTextBox i = 2 Do While...
  5. L

    Conditional Formatting Shapes that contains specific words

    Hi to all! My question regards a vba code. How to conditional Formatting Shapes in a sheet? I have a product list on sheet1 Many shapes on sheet 2, linked to every cell in sheet1 that contains that product name. I need to color the background of every shape, if they contains the word for...
  6. M

    Keep source formatting when pasting ranges to a shape

    Hi all I have a workbook with 2 different worksheets. In the first worksheet you type in different information. When clicking on the other worksheet the data from the first worksheet is then copied and pasted into shapes in the second worksheet. I have a challenge of keeping the source...
  7. W

    VBA to change multiple shapes color in Excel

    I'm beginner in Excel so i'm looking for a way by which if I type yes in a cell it should change color of multiple shapes with same color and if I type NO it should remove the color from those shapes and same goes for other zone entries as show below image. Example: If i type On in G22&25 it...
  8. D

    VBA Loop Though Column of Data, Select Shape in offset column

    Hi. I'm trying to figure out how to loop through column "I" If it finds a cell that is blank, skip the row, move to next row until it finds a cell containing a value Once it finds a cell with a value in column "I", select the picture in column "B" of the same row. Once the picture is selected...
  9. A

    How to disable shape copy paste with vba in worksheet - please check this

    i have few flowchart shapes in excel sheet. which i use for label designing purpose. but i don't want to allow user to copy paste selected shape object in same worksheet. Application.copyObjectsWithCells = False Application.CutCopyMode = False The reasons for not allowing copy paste to...
  10. P

    VBA to create, place and name Shape from Values in cells

    Hi, I need help with this: In cells A1:A6 I have Name of Shape In B1:B6 I have refference to another cell in form D2 in cell B1 , E3 in cell B2 , C6 in cell B3 and so on. I need to create multiple Circular Shapes named after A1:A6 and placed into refference cells, which is in B1:B6 and loop...
  11. G

    Convert a shape (group) into a picture inside wrksheet using VBA

    I am obsessed with terse code. The code below does the job (I recorded this macro): Sub copy_and_paste_as_picture() ActiveSheet.Shapes.Range(Array("Group 5")).Select Selection.Copy ActiveSheet.Pictures.Paste End Sub Can someone help me clean this up and turn the three lines...
  12. K

    Change shape size (Rectangle) based on two cell values (Start Date) & (End Date) Excel 2013

    Hi Excel Guru's, Im trying to create a scheduler where in a shape (rectangle) will be based on two cells (Start Date) and (End Date). Both shapes and date values are on the same sheet. Can you help me? Advance thanks to you all.
  13. Jaafar Tribak

    Class for Zooming on images (Picture Shapes) displayed on worksheets.

    Hi all, I thought I would post here this vba code, which as the title says , it allows zooming In\Out on worksheet images. I was prompted to write the code by a question asked recently here : The...
  14. L

    Shape Array TopLeftCell.Address

    Hi I working with a series of shapes on a worksheet where I am holding the shape data in a array and then writing each shapes TopLeftCell.Address into another worksheet to do some calculations. The problem is the For loop is slow due to the number of iterations it has to go through. The...
  15. G

    Help with Shape scroll or ******* show last empty row

    Hi everyone, I have a shape on a worksheet that when clicked opens a userform to add data, what i would like to do is add to my exsisting code so that when the shape is clicked it not only opens the userform it also scroll the worksheet to the next empty row. Below is my code to call the...
  16. N

    Create a honeycomb pattern with the hexagon shape

    Hi, How can I automatically create a tessellated honeycomb pattern on a sheet, using the hexagon shape? Ideally, I want to be able to use 2 variables for row & column and create a honeycomb based on those values I hope this makes sense!
  17. D

    Using VBA to insert different headers

    I have a start up page for my spreadsheet that allows a user and a site to be selected. Depending on the user, I want a signature that is stored on the sheet Users, inserted in the following format onto sheet1. The signatures are stored in sheet 2. Dim shp As Shape Set shp =...
  18. T

    Macro to spell check just the words in a texbox?

    Hi Everyone, I need a macro that when it runs will check the text in a standard shape textbox called "Words 1" please help if you know how to do this, thanks Tony
  19. N

    Enable / Disable Shapes

    Hi All, I have a excel template where I have 8 shapes created as button and assigned a macro to each shape. Is there a option to disable the Shapes where the users are unable to click the shapes to run the macro. For example: I have a shapes with names Login and Logout. When the excel is...
  20. A

    Deleting Lines and Rectangles

    Hi, I have a need to delete many shapes on a worksheet although I wish to keep others. All of the shapes that I wish to delete are either lines or rectangles and the ones that I wish to keep are not. I had hoped the following would work, but it doess not - can anybody let me know what the...

Watch MrExcel Video

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