autoshapes

I have a macro to copy and paste information from one sheet into another, looped to cycle through the different drop down options at the top of the page (i.e. you end up with one separate tab for each drop down option) One part of the sheet contains text boxes linked to specific cell values...

Good evening all, I have created a map formed of 24 shapes, which I would like to change the colour based on a cell value. each shape will link to a cell. When the cell value changes depending on the value the colour of the auto shape A reduction green, increase red, and no change Amber. I...

I have a worksheet with a column of various sized and colored arrows (AutoShapes) in column T (T5:T19). In column S (S5:S19) I have corresponding numbers. I want to lookup the numbers in column E from the table (S5:T19) and return the corresponding arrow shape in column F. Is this possible...

I was browsing for a solution to my problem and found a thread that almost does what I need but not quite. http://www.mrexcel.com/forum/excel-questions/305014-rename-autoshape-adding-text.html This code creates 4 hard coded trapezoids and adds the text based on 4 preset cells. I need a...

Hi all, I am writing a workflow program for my work. It essentially creates a rounded rectangle auto shape for each new ticket. It then populates the text of the ticket with the ticket number and summary text. This was working fine on several machines including my own (all running Office...

Hi I have been using Excel 2003 for a few months now and creating a form on a sheet as opposed to a Userform is preferred due to it's versatility with Autoshapes. However, I am now working from Excel 2010 and trying to do the same thing. Everything about 2010 is better for this task other...

Hi, In a previous post I read, it mentioned that it's possible to specify absolute coordinates for an excel shape e.g. rectangle. I've tried recording a macro whilst moving a shape around but to no avail, see below, ActiveSheet.Shapes("Rectangle 1").Select...