1. D

    Coloring of different shapes based on time

    Hi There, I am trying to solve the problem with coloring the shapes based on time and I am struggling with it for some time so hope someone can help me with this. I have 19 shapes on excel sheet and each is having the name Bankomat_ and then number from 1 to 19. The output should be that...
  2. A

    How to allow moving shapes, but prevent editing their text on a worksheet

    I have a challenge to overcome, but couldn't find any hint yet and hope you guys can help. I need to create shapes (e.g. msoShapeRectangle) with specific texts in them in a worksheet. Once created, I want to allow users to move the shapes on the worksheet, but I want to prevent them, editing the...
  3. R

    Move (grouped) shape 5 columns to the left

    Hi all, I've got a grouped shape that will move based on the cell value entered in cell A1. Now I want this grouped shaped to always move 5 columns to the left. So when I enter value M8 in cell A1 VBA should automatically move the grouped shape to H8 (at least that is the upper left corner of...
  4. Ruts

    Updating Text Format in a Shape using VBA

    Hey everyone, I wrote this bit of vba quite some time ago (2017) to run a little bingo caller for a social team where I was - keeping excel up to date wasn't something they were good at - so the version at the time worked. They have now updated to O365 and the reformatting of the text in the...
  5. S

    Wait Until new shape selected

    Good Evening, I'm a novice at best. I'm looking for a faster way to name shapes that make up a large map using a given array. Given: - An array "Districts," which has more than 300 text strings (district names) stored in it -- The district array has no spaces or special characters in it -...
  6. S

    Moving a shape without explicitely naming the shape

    Hello, Using the moderator, from this site (Fluff)'s help a couple days ago, a sequence of code was developed that showed when clicking on a cell the name of any shape that was currently located directly within that cell or astride of its borders. That worked great thanks to Fluff. But the...
  7. R

    Updating Objects in Different Groups in the One Worksheet

    I have a worksheet where a map has been created using a number of freeform objects. Each of these objects has been assigned the name of the territory which it represents. I then have a list of each territory, with a reference to the fill colour required. I have this working with the first...
  8. S

    Filled shapes becomes transparent when changing sheet through VBA

    Hi, I've tried to utilize VBA to enable smooth transitions between sheets. When activated a square shape is moved into cell A1 and gradually fills the screen before the sheet is changed. On the next sheet a similar shape is gradually becoming transparent (and later moved out of sight) to...
  9. H

    Convert group of shapes to picture

    Hi, I'm working an a project where I try to convert a group of shapes to a picture and then delete the group. Shortly how I done so far: (the s_text, s_header etc. are programmatically generated shapes) Dim shpGroup As Shape Set shpGroup = sales_sheet.Shapes.Range(Array(s_text.Name...
  10. Worf

    VBA – Transferring picture to worksheet pixel by pixel

    Say that you want to analyze the color distribution of a given picture. One way to do this is to have each worksheet cell representing one image pixel. To use the code, run the transfer routine, specifying the sheet and the shape name. #If VBA7 Then Public Declare PtrSafe Sub Sleep Lib...
  11. M

    Resizing textbox based on the table height next to it.

    Hi I have a few tables and a few textboxes next to the tables. I want the textboxes to expand when new rows are added to the table. The range would be dynamic hence I have to find the textbox in the specified range and then adjust the height. I tried to code it but the height of the textbox...
  12. R

    Issue with Text in Shapes

    Hello, For some reason whenever I open up my workbook, the text in my shapes has automatically moved to the back so that it appears like there is no text in the shapes. So every time I re-open the workbook, the first thing I have to do is click on a shape and send the text to the front. This...
  13. Worf

    Manipulating shapes with VBA

    Here is a description of this application: Canvas sheet - shows your current work. Problem sheet - presents the original problem and also some examples that can be pasted on Dat page. Dat sheet - There are stored triangles vertices generated by the program. Alternatively, you can insert your...
  14. M

    After change from Picture.Insert to Shape.AddPicture picture image is shifted

    Hi, Hi I had to modify excel template VBA code to make image logo persistent outside the network so I change simple Picture.Insert(pfile) to: Set vOldShape = vSheet.Shapes(pName) If Not vOldShape Is Nothing Then vLeft = vOldShape.Left vTop = vOldShape.Top...
  15. P

    VBA to check if circles are inside of freeform area or not

    Hi, Im newbie on this site and I need help with this : I have Freeform area and shapes in form of circles named from A to G. Some of this points are inside of Freeform area and some of them no. I need macro which will check each of this points if this point is inside/ outside of freeform area...
  16. G

    Help with vba to scroll group of shapes

    Hi everyone, I have shapes in my worksheets, these shapes have been grouped, i am trying to get these groups to scroll down as the user scrolls down the worksheet. Below is the code i am using, my problem is that it keeps bugging at line Set myGroup. is there something wrong here that i can...
  17. 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...
  18. 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...
  19. G

    Freeze a shape

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

    How to change visio shape text based on worksheet row content using for each loop?

    I created this for each loop to add the devices ip address to the shapes text it find the devices if i put a static name on the code but It doesn't look like is reading the worksheet names from column A When I change the loop and write one of the shapes name on it I'm able to change any of the...
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.

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