1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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.
  6. 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...
  7. F

    VBA With statement: How to copy grouped items?

    Hi, I have previously created a chart and copied it to another sheet. But now I have added a text box and grouped the text box and chart together (not in VBA). I want to be able to copy the group to another sheet as a picture. I believe instead of "Chart" it's "Shape" in VBA. But I don't know...
  8. J

    default to not move or size shapes?

    Is there a way, like creating a template, that will default to"do not move or size" shapes"?
  9. D

    VBA to cycle through values to change colours of various shapes

    Hello there, I have a range of shape names followed by various values which correspond to the colours which I'd like to assign. I'm having problems piecing together the VBA code in order to update the shapes in one go. My data source is on the sheet named "Data" with the shapes on one called...
  10. D

    Deactivate connectors from shapes

    Hi all :) Does anyone know a VBA code that would allow me to deactivate connectors from shapes. Here see an example Because what I would like is to turn the shapes at 180 degrees without moving the connectors. That's why I'm...
  11. G

    How to ignore Overlapping shapes with VBA code

    The code as is works in most situations however sometimes when a bar slightly over laps it will count in the range and sometimes I can't get it out of the range. This code is going into a document that I don't use it's used by other people who produce a schedule and for whatever reason they have...
  12. D

    Rotate text in cells or in shapes by 180 degrees

    Dear all, Does anyone know any VBA code that would allow me to rotate text by 180 degrees in specific cells, kmowing the texts contained in the cells are linked to specific shapes. I want to keep the text and do not want an image ... I'm open to any ideas, even if it's include to use Word or...
  13. D

    Shapes linked to single cells not updating

    Hi, I've been looking all over the place for a solution to this but have yet to find one the fixes my problem permanently. I'm new to the forum so please let me know if something is incorrect with my post. I've created a dashboard on excel that mainly consists of tables and graphs; but I also...
  14. T

    Change default color for shapes

    I like blue as much as anyone but not for geometric shapes like lines and boxes. How can I change the default color to, say, black?
  15. M

    Dynamic Shapes

    Hello, I'm looking for a way to change my shapes based on a value. Either by a formula or code. I have a ton of numbers that I want to show with arrows for positive/negative/flat. (Green Arrow up/Red Arrow down/Sideways Arrow) Thanks in advance for any help on this!
  16. P

    Copy pasting data from excel to outlook

    Hi All, I have a data in excel sheet which I would like to send as email body. In my sheet I have few lines of text few charts, shapes and Pics. Im currently using a code which will copy paste the data to an email. But in that draft email if I scroll down to view the email body the shapes in the...
  17. P

    Copy pasting data from Excel to Outlook

    Hi All, I have a data in excel sheet which I would like to send as email body. In my sheet I have few lines of text few charts, shapes and Pics. Im currently using a code which will copy paste the data to an email. But in that draft email if I scroll down to view the email body the shapes in...
  18. Z

    Change specific text font color in shapes

    Hi, I have shapes that have text and I need to change the text font color of any "please change color to blue - example" if it's found in shapes. How can I do that in a macro?
  19. T

    WithEvents for a Shape

    I am trying to find an event for a shape but this does not work: Public WithEvents ShapesEvent As Shapes because VBA doesn't recognise Shapes. What should I declare it as? Thanks
  20. A

    Creating dynamic list in shapes

    Is there any way to create a dynamic list in shapes? For eg. I have a table with follow up dates against the companies. I want to insert a to do list in the dashboard where the user can select a date and he can view the list of companies that needs to be followed up with on the given date. I am...

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