shape

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

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

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

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

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

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

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

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

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

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

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.

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 :https://www.mrexcel.com/forum/excel-questions/1110968-zoom-image-picture-displayed-workbook.html The...

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

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

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!

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

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

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

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

Is there a way to freeze a shape so that it behaves like freezing cells? I want to freeze a shape so that it always stays on the screen even when a user scrolls.