drawing

Hi all. I have written a workbook that allows me to display chords for the ukulele (I am left-handed and I cannot find a left-handed version on the internet anywhere.) In order to do this, I have created a drawing object by grouping together various lines and rectangles, to mimic the fretboard...

Hello I closed my PC for a week. After re-opening Excel give me a message that it did found some error and re-opened it. Now, my main page is displaying only the formula. No format nor drawing is shows. All drawing was linked to a macro. I don't found the proper way to explain the problem...

I am trying to run a userform in full screen on opening a workbook then place a plan view drawing of a site at full screen and on that drawing have "hot spots" ie command buttons that carry out an action. Thats the broad brush stroke of my requirement. My issue is maintaining the relationship...

Hi all, Inspired by a question asked by a forum member, I wrote this code which should allow the user to draw freely (like a pencil using the cursor) on an userform The code also allows to copy the drawn picture to a newly created worksheet shape as well as to save the drawing to disk if...

I have charted a couple of spirals on a worksheet and now want to connect the the corresponding points between each spiral with a line. There are 700 points in each spiral, not something I want to set up manually. Can I write a macro that selects the chart, reads a pair of coordinates from...

Hello world! This is purely for visual "scale confirmation" and aesthetics, but I know it is possible and I'd like to implement this into my userform. I've got users who will be selecting between different shapes (during quoting) that we will be cutting in our steel shop. If they select our...

Hi, I've been trawling forums for two days now for an answer to this, but with no luck. All I want is the ability for a user to draw within a UserForm, and then what he/she draws to be displayed within a worksheet. InkPicture would seem the correct control to be using, but I can't find a way...

I am struggling with the “'Read specified shape data fields from all shapes on all pages of all drawings in directory” portion of the code. I am not familiar with the syntax needed here, and also I’m not sure if I have to create objects and set objects to accomplish this. One other part of the...

Hi, I have a large flow diagram where I've drawn arrows by inserting shapes. When I scroll around sometimes the lines are there, sometimes not - I have to keep on scrolling around until they turn up. Is this a bug? Or is there a way round this? I'm using Excel 2007 with SP3 It is really...

Hello, I am using 2007 and am trying to control the text of a textbox choosen off the insert menu. Sheets(1).Shapes("textbox 12").Text = "hello" Using this line gives error 438. Object doesn't support this property or method. My goal is to basically have a macro fire when only cell a1 is...

Hi, we're trying to emulate "Kanban" charts in Excel - using drawings so we can easily move tickets arounds the worksheet. However is there a way of being able to "find/search" for text within drawings in an Excel worksheet? thanks

I am trying to run a macro to draw a number of bulletcharts as graphics (similar posting on the blog http://sparklines-excel.blogspot.com/) The process steps through each instance of the formula, draws a shape that fits into the indicated cell, then further shapes are combined to produce the...