# Drawing Grid

Nov 26, 2007

I want to have 2 cells where I can enter 2 numbers (length & height) so that a grid can be plotted. For example, a big sheet of paper size is length 30" x height 8", if first number is 10" (length) is entered, it will plot 3 lines across 30" (cos 30" divided by 10" equals to 3) and if I enter 2" (height) on 8", it will then cut it into 4". Attached a file for better understanding.

## Performance And Potential Grid (nine Box Grid) - Multiple Values

Oct 24, 2013

I created a table where based in several competences anyone can evaluate performance and potential. My issue comes when based on that result (colum Y in "Perf&Pot" Sheet) I want to export that to a nine box matrix (Sheet 2 "grid" in the attached excel). As could be several people in the same box I wasn't able to com up with a formula that solves this.

Pasta1.xlsx

## Cant See Drawing Toolbar

May 22, 2007

I've recently got a new computer and this problem is driving me nuts.
When I click view!toolbars!drawing, nothing happens. No drawing toolbar appears at the bottom of the screen where it used to be. There's a small "drawing toolbar" icon on the main toolbar, but whether this is depressed or not makes no difference either.

I understand this may be changed in the 2007 version, but I’m using Excel 2000

## Corresponding Value Drawing According To Rule

Oct 29, 2013

In my attached sheet I've to find out final result in Column "F" (green shaded). My boss many times a year increases salary by certain percentage (say 30% or 40%) which is given in "E" column. After that I need to adjust it according to Pay Scale given in right side. For example one Executive's salary reaches 19880 after % increase. Now in pay scale we see in executive (row no. 13) it crosses 19800 so his final salary should be next upper value i.e 20600 (if it reached to 20700 after % increase, then his final salary could be 21400). That is final salary should be multiple of designation's increment plus minimum gross salary (Here 800X10=8000+11800=19800, since it exceed by 800, so salary should be 800X11=8800+11800=20600)

So we can either pull data from right side table or we can give formula in "F" column to get the required result.

## VBA Drawing Objects

Jul 15, 2008

I want to use VBA to update a drawing object's color, such as a circle.

For example, pretend I am counting sheep and I need to know when I have reached the maximum count by the visual aide of a stoplight. The script in my head reads: If the max. count of the sheep is less than 5, then the stoplight is green. If the max. count of the sheep is equal to 5, then the stoplight is yellow. If the max. count of the sheep is greater than 5, then the stoplight is red.

Is there a way to do such a thing on excel and with VBA?

## Drawing A Line With VBA

Jun 22, 2009

How would i have VBA draw a line between a two ranges? say i have a named range of "start" and another name range "stop". i want to draw a red line between them. how can i do that with code. this is beggining my education for a much larger project I want to do later in the future.

## Drawing Circle And Rectangular Using Vba?

Sep 15, 2014

is there a code to draw a circle? by supplying the center position and the diameter? for example cell "A1" and " A2" are for the center of the circle position and "A3" for the diameter? and whats the code for drawing a rectangular by supplying the starting position and short length and the long length?

## Drawing Circles And Other Shapes?

Jun 16, 2013

I want to draw circles from 3 points and other geometrical shapes. The points will be given from clicks on the background picture.

## Drawing ComboBox From IE For Use In Excel VBA

Jun 18, 2013

Any way to retrieve values from a combobox on a webpage (For my case there are two values in the combobox.) I know how to manipulate the webpage to choose the values in the combobox and so on but i want my user to be able to see the options they have from my userform.

## Drawing Lines With Macro

Jun 4, 2007

I am having trouble writing a macro that will draw a line relative to what cell is currently selected. I can only get the macro to draw a line in one specific spot.

## How Can I Tell Which DRAWING Textbox Is Active

Sep 26, 2008

I have a sheet with 30 textboxes made with the drawing toolbar. The user enters data, then clicks on a button which formats the page to adjust row size to match amount of info. I am having trouble finding the code to store the currently selected textbox in a variable so that I can place the focus back to the same textbox when the macro ends. Can anyone help me with the code to get the active textbox?

## Drawing A Line On A Userform

Nov 15, 2008

I know you can draw a line on a userform by providing the start and end co-ordinate of where you want it, but is it possible to have a UserForm appear on call, with the 1st co-ordinate already set (by the programmer) and the user clicks on some point of the UserForm to indicate where they want the end co-ordinate to be, and that a line would then be drawn to that point ?

## Drawing Lines In A Macro

Aug 28, 2009

I want to draw a (time) line from the top left corner of a cell (say C3) to top left corner of a cell (say i10) in a Macro. Both start and end cells (column & rows) will vary depending on certain input values which I can convert into a cell reference. Line must overlap on both ends by two column widths.

## Hide Drawing Objects

Mar 6, 2007

I'm looking to write two small macros that will either hide or show all lines, freeform lines, and autoshapes on a page. In my extreme competence, I determined a for/next loop would be appropriate... but other than that, I can't figure out where to start.

## Grid To List

Jun 15, 2009

I'm not worried about the order of the data. What I want is information on turning a grid into a list.

## Lookup Value From X - Y Grid?

Jan 16, 2013

I'm creating a fairly large risk analysis spreadsheet which uses a fairly standard 5x5 risk matrix.

I need a function or a formula which refers to the score a cell in a 5x5 grid, if given the row and column values, like this (where the columns are probability and the rows are impact):

VL
L
M
H
VH

VL
1
2
4
6
7

[Code]....

## Drawing Tangent Line On Curve?

Mar 8, 2014

Can we draw tangent to a curve in excel graphs..? If yes if i could have some demo....** this.. I am working on finding rate ** change at an instantaneous point and average rate ** change ie: secant line

## Drawing A Blank On How To Sum Cells With Like Data

Feb 5, 2010

I have a worksheet with 27,000+ rows. Item numbers are listed in column J and quantities in column E. The rest of the data on the sheet is not needed. An item number may be listed multiple times. I'm trying to create a new sheet that lists each item number once with the sum of all the quantities associated with that number. The data is sorted so all "like" item numbers are listed in consecutive rows.

## Drawing Multiple Charts On Same Worksheet

Mar 15, 2012

I am working on a huge amount of data and want to analyse that data through charts because charts are quick representation of the data and save a lot of time. I got some code from my friend, to read each row in a worksheet and plotted the corresponding chart on the new worksheet each time i.e., each row has one chart which is plotted on new worksheet each time.

But I don't want it to plot the chart on the new worksheet. I want it to plot the chart on the same worksheet. In my case there are always more than 30 rows, so it should draw 30 charts on the same worksheet in which 30 rows are written.

Here is the code which plots charts on the multiple sheets

Code:
Sub LineCharts()
Dim Ws As Worksheet
Dim NewWs As Worksheet
Dim cht As Chart
Dim LastRow As Long
Dim CurrRow As Long

Set Ws = ThisWorkbook.Worksheets("Sheet3")
LastRow = Ws.Range("A65536").End(xlUp).Row

[Code] ....

## Drawing Line Segments In Excel With VBA

May 8, 2012

I'm trying to draw a diagram with many nodes connecting several line segments.

Each has a colour attribute which I'd like to show on the graph.

How can I plot it to-scale using VBA in excel?

TypeCoord1Coord2Colour
Node0 0 Yellow
Line0 1 Black
Node1 1 Red
Line1 3 Blue
Node3 3 Purple
Line3 9 Orange

## Drawing Figure According To Data Feed

Jan 4, 2013

Is there any method in excel that can pay the way for drawing figures according to data feeded.

for Ex.

Say

Now this x can be used for drawing the circle and the radius can be entered by user.

## Drawing Shapes Behind Plots On Graph

Jan 17, 2010

I'm currently drawing rectangle shapes with transparency on top of a graph to highlight certain depth ranges in vba. Rectangles span entire graph width. Is it at all possible to draw the shapes behind the series plots?

## TextBox (Drawing) Text In Find

Nov 2, 2006

I have a macro that runs when a text box is clicked and searches in another excel sheet for a cell with a specified value. My problem is that I specify the string to search for in the code and I would like it to search for the string in the text box that gets clicked.

Here is what I have right now: ...

## Prevent Some Drawing Objects Being Modified

Nov 25, 2006

How do i preventing drawing objects from being modified/ deleted/added on an excel worksheet? edit: but i want people to be able to interact with them i.e. people shud be able to enter text into textboxes.

## Change Drawing Object With Cell

Jul 17, 2007

I want to draw an object and then change the object shape by making subsequent changes in the cell.I don't know how to do the same.

## Grid Header From Cell Value

Jun 29, 2013

Example.xls

Within my attachment, I have a grid of data, Row A are headers, and beneath, various corresponding dates, there are no row headers.

I'm trying to do a lookup so that column header is returned bases on a exact cell value.

Example: inputting 03/03/2014 will return "Week 3"

Week 1|
Week 2|
Week 3|
Week 4

07/07/2013
|14/07/2013
|21/07/2013|
28/07/2013

[Code] ......

## Linking Grid To Combobox?

Mar 6, 2014

I'm trying to link objects and pricing to groups via a combo box. If the user selects Group A from the combo box and enters Object A on the line item, I want the price associated with Object A and Group A to populate.

Group A
Group B
Group C
Group D

Object A
\$1
\$3
\$5
\$7

Object B
\$2
\$4
\$6
\$8

Object C
\$3
\$5
\$7
\$9

Object D
\$4
\$6
\$8
\$10

## Marking Grid Points

Nov 18, 2008

I have a worksheet ('Matrix') that has a grid that is 40 rows x 40 columns. On another sheet ('Drivers') I have a two columned table where a user is enters two numbers between (you guessed it!) 1 and 40. What I'm trying to do is within the grid, have a "Y" appear on the crossing point as denoted by the table. I've tried a couple of experiments with MATCH, but I'm not getting very far.

I've attached an example document to make this a bit clearer and I've coloured the references on the 'Drivers' sheet to correspond to where they should appear on the 'Matrix' sheet. Sorry if that's a bit garbled. Let me know if you need any clarification.

## List Box To Use As Data Grid

Aug 13, 2008

about using list as a datagrid type. I was able to research some samples and applied it on my own, but unfortunately I am missing something again here. The data on the worksheet are not being populated when my range is on the AA column. It works with A1 column but not the far ranges. Im not sure about the limit of range anyway here is the

## VLOOKUP & Grid Names...

Oct 15, 2008

I'm having an issue with VLOOKUP, I'll keep it short as I don't think I need loads of details because I have done some troubleshooting and believe got to the cause of the problem... I just don't know how to fix it!