Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Excel


Drawing A Line With VBA

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.

View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
Drawing A Line On A Userform
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 ?

View Replies!   View Related
VBA Drawing Objects
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?

View Replies!   View Related
Drawing Grid
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.

View Replies!   View Related
Cant See Drawing Toolbar
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

View Replies!   View Related
Drawing Lines In A Macro
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.

View Replies!   View Related
Drawing Lines With Macro
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.

View Replies!   View Related
How Can I Tell Which DRAWING Textbox Is Active
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?

View Replies!   View Related
Hide Drawing Objects
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.

View Replies!   View Related
Drawing A Blank On How To Sum Cells With Like Data
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.

View Replies!   View Related
TextBox (Drawing) Text In Find
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: ...

View Replies!   View Related
Prevent Some Drawing Objects Being Modified
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.

View Replies!   View Related
Drawing Shapes Behind Plots On Graph
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?

View Replies!   View Related
Change Drawing Object With Cell
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.

View Replies!   View Related
Circling Text Within A Cell Without Drawing Tools
I can't find anywhere where there may be some VB code to allow text within a cell in Excel to be circled. I don't want drawing objects, because many times I need to modify 30-40 sheets at one time and Excel doesn't allow you to alter drawing objects when you have multiple sheets selected. Therefore, I just want to be able to apply a circle around some text in a cell the same way you would underline it, for example. I figured my only hope is VBScript?

View Replies!   View Related
Link Drawing Toolbar TextBox To Cell
Is there anyway to automatically update a value in a cell to a texbox?

In sheet1, there is a value of 2.3 in cell A1.
In sheet2, I have a textbox created from the Drawing Toolbox.
The content in the textbox would always be " Total (Sheet1.A1.value) Months"

View Replies!   View Related
Retrieve Drawing Numbers Associated With Part Number
I have a list of part numbers and a new drawing number and old drawing number. I'm am trying to put this list on the second page of a workbook and write a code on thie first page that allows a person to enter the part number and the old and new drawing numbers will be displayed.

View Replies!   View Related
Cell Values In A TextBox From Drawing Toolbar
I know that I can enter =$A$1 in a text box. But is there any way to concatenate more data with it. I would like to hase something like.

="Bill " & $A$1 & " Gates"

but Excel will not allow.

View Replies!   View Related
Convert Macro In 1 Line To Multiple Line Code
i hv following code

(i use generate macro)

my question is how to arrange the code from one line to multiple like :-

following code show in excel macro environment is one striaght line.

' Create new var on yr , and replace 2006 to CY06.

ActiveCell.FormulaR1C1 = _

View Replies!   View Related
Report A List Line By Line Based On Name Criteria
Currently I am using Excel 2000. I did a search and couldn't seem to find the answer I was looking for. Hopefully someone can help. It would be greatly appreciated since I have been trying to figure out how to do this for days.

I am trying to create a worksheet that will pull info from a row on one sheet to another sheet based on the name; then continue to list the info on each line afterward until there is no more of the that particular criteria. See below (this is just an example to simplify the data but would need the same process):

This would be the data on sheet 1:

Name Bonus Commision

Tom $45 $50
Mary $25 $75
Mary $30 $80
Tom $60 $50
Tom $90 $25

What I would like to do is have 2 more sheets. One would be Tom's sheet and the other would be Mary's sheet and it would look like this:

Tom's Sheet:

Tom $45 $50
Tom $60 $50
Tom $90 $25

Mary's Sheet:

Mary $25 $75
Mary $30 $80

I am not completely familiar with all of the functions in Excel and compared to you guys I am a complete novice.

Is this possible to do in Excel without using a macro?

View Replies!   View Related
Table Of Contents - Drawing Info From Various Cells On Different Sheets
I have a "Generate Table of Contents" button that launches a macro. This macro builds the Table of Contents, creates (3) columns (Patient Name, Date of Pickup, and Frequency), finds all of the sheets in the work book (already renamed to a patient's name), sorts them alphabetically, and lists them under the Patient Name column.

This code works great - The next challenge:

On each sheet (which corresponds to a patient in the database), there is a cell that is filled in that states which day the patient picks up their medication. There is another cell that designates how often they come to pick it up.

I am at a loss as to how to direct the macro to: For each sheet, go to the specific cell, and then report it in the table of contents.

It somehow needs to bind the information together... meaning the patient name, date of pickup, and frequency must be displayed correctly each and every time on the same row.

View Replies!   View Related
Drawing Straight Lines In A Chart And Mark Intersections
Drawing Straight Lines In A Chart And Mark Intersections. I want to make a graphic like this in Excel.

View Replies!   View Related
Change Source File Of Linked Drawing Object
I've inserted a Solidworks drawing into a worksheet & wish to change the displayed image using VB. I suspect this could be done by changing it's source file, but can't get the code to work.

View Replies!   View Related
Put All Values Of A Specifice Line In That Matrix In A Line
I'm working with matrix in vba and i'm trying to put all values of a specific line in that matrix in a line in excel. For example:

Matrix =
1 2
3 4

and i want Range("B1:B2") = 3 | 4 (the second line of that matrix).
Is there any way of doing this without perfoming a loop?
[something like Range("B1:B2").value = 'range'(matrix(0,0) , matrix(0,1)) ]

View Replies!   View Related
Line Graph Not To Continue The Line If There Is Nothing In Row 10 Of The Table
With the attached spreadsheet i cannot workout how with the line graph not to continue the line if there is nothing in row 10 of the table.

for eaxmple if there is no value in cell M10, i would like the actual addtion line to stop at the last value on the graph that was in L10.

View Replies!   View Related
Delete A Line.or Rather A Line On A Line
I have a spreadsheet where there is a white line that is over a row line. No matter what I do I cannot seem to delete it.

I zoom in but I cannot select it.

I change the border of the cells and it will not disappear.

I am completely lost as to what else it could be, no doubt it is a simple answer that is staring me in the face. I inherited the spreadsheet so not sure what was done in the past.

View Replies!   View Related
Line Graph: (line Graph To Display An Amount Over Time)
I want to use a line graph to display an amount over time - that's the easy part. On the other hand, I would like to have to group the lines based on a value.

A short example:
Imagine you own 3 different stores and you're selling oranges. So your table looks like this:

Now I'd like to have one graph (3 different graphs won't work as the rows increase -I need to select the whole column as data source):

Date on the x axis,
Oranges sold on the y axis,
and one line per store (e.g. a green one for store A, a red one for B and a blue one of C, doesn't matter).

View Replies!   View Related
Add A Line
I have a very simple spreadsheet. Two columns: Date and Comment. I would like my employees (2) to go in and leave each other messages. I have setup conditional formatting so that when they enter their names the row will format with a different color for each person.

What I would like to do is:

That when they hit the enter key at the end of their comment that a new line is added above this line.

What I am trying to do is have their comments entered in ascending order so that the latest comment is always at the top. These two employees are completly excel illiterate and I really dont want to do the sort function.

They will be entering data on a daily basis.

I did do a search but couldnt find anything that helped me.

The rows start at A4 through B50.

View Replies!   View Related
Add A , To The End Of Every Line
i have a list of customers email addresses. They are all in column A and just go down one at a time. I Just tried to import them into outlook and to cut long story short they need to be separated by a , at the end of each email address

View Replies!   View Related
Replicationg A Line
I have a list of names, and a list of number beside the names.

What I need to do is replicate the name in cell a1 by the number specified in b1 and then move on to the next row.

jim 3
alan 2
bob 5

what I need to end up with is



View Replies!   View Related
Getting The Line To Loop
How do I adjust this code to loop through 100 columns eliminating the need for the same line 100 times

Sub loopthroiugh()
Range("D4").End(xlDown).Offset(1, 0).Value = "Blah"
Range("E4").End(xlDown).Offset(1, 0).Value = "Blah"
Range("F4").End(xlDown).Offset(1, 0).Value = "Blah"
Range("G4").End(xlDown).Offset(1, 0).Value = "Blah"
Range("H4").End(xlDown).Offset(1, 0).Value = "Blah"
Range("I4").End(xlDown).Offset(1, 0).Value = "Blah"
Range("J4").End(xlDown).Offset(1, 0).Value = "Blah"
Range("K4").End(xlDown).Offset(1, 0).Value = "Blah"
Range("L4").End(xlDown).Offset(1, 0).Value = "Blah"
Range("M4").End(xlDown).Offset(1, 0).Value = "Blah"
End Sub

View Replies!   View Related
Certain Line Only Calculations
I am making a spreadsheet that tells us the following information about prints that we do:

View Replies!   View Related
Multiple Best Fit Line
I have excel 2007, i am doing scientific graphing via an X Y scatter plot graph. Is it possible someone could give me step by step instructions on how to fit multiple best fit lines. In particular two lines one for the upper portion data and top portion of curve. The second on the flatter bottom portion ultimately intersecting in the left inner portion of graph. the graph plots appear as a rounded L.

View Replies!   View Related
Line Charts
Has anyone seen this problem before;

I used a "MID" formula to extract some data and for some reason the chart I'm trying to use won't recognize the data. Here is a copy of what the data looks like. Non of the vaules will show up on the chart.
DPJE2DD2CE2CJan1.2784.8984.8997.65Feb1.2697.6597.6591.79B10==MID(B$3,8,5)Mar1.3091.7991.79154.7Apr1.28154.7154.7147.6May1.29147.6147.687.78Jun1.4387.7887.78112.6Jul1.39112.6112.6115.2Aug1.42115.2115.293.6 Sep1.3393.6 93.6 138.9Oct1.28138.9138.9NovDec115.6YTD1.32115.6115.6

View Replies!   View Related
Line Code
I have the following line from my code of which I am having trouble with I get an error:

If Left(IRange, 1).Value "1" Then
I am trying to find the first string in cell range ...IRange ... I know the Left function = Left(string, length) but can I reference a Range or perhaps cell location within the string argument??? This can be done in excel formulas, but can it be done with VB code??

IRange = Cells (iRow,iCol) and value in cells are Long

My goal is to try and find out how I can use my excel formula:

Left(D3,Find("1",D3)) and impliment this to my above VB line

View Replies!   View Related
Cant Get The Boxes To Line Up
I have a form where there are a lot of check boxes and there is a print version button. It is so when you complete the form you click print preview and it removes all the unused lines and formats the form to be ready for print. Everything was working fine until I had to add another line of check boxes and now first row skips a cell after formatting.

View Replies!   View Related
Line Bar Rostering
Line Bar Rostering ...

View Replies!   View Related
Line Up Cells
I have a workbook with 2 groups of data on it side by side. Goal here is to have them line up. The problem is one side has more data then the other OR the smaller side may have data thats not in the larger side.


Accnt #, Name, address Acct#, Name, address

I would like:

1234 Mike Thomas 1234 Mike Thomas
1234 Jayne Thomas 1234 Jayne Thomas
1235 Chris Beaton
1236 Susan Hamel 1236 Susan Hamel

View Replies!   View Related
New Line In Msgbox
How can I create a return / new line in a MsgBox? I'd seen documentation to use the @ symbol to trigger a new line, but that doesn't seem to do anything.

View Replies!   View Related
Command Line
Is there any way to run a command line from excel?

E.g. i want excel to call this command:

ping and then return the result to a txt file?

View Replies!   View Related
Add New Line, Merge Two Tables
I have been working on a project for a few days now, it is almost finished but I am struggling with creating macros. I will send a file in the attachment and I will tell you what I need to accomplish :

1. I need to add to every sheet a button " add new record" - this button will add a new line and copy the formulas and dropdown menus + formatting from the last line , but not the actual data. The numbering will be 1. 2. 3. etc .. in the first column.

2. I need to create in the Price offer sheet the last line that will sum up the total weight and the total price of all the products ... this line will be always the last and the "add new record" lines will be added above the summary line.

3. I need to create a drop down list in Price offer sheet ( via validation data and Vlookup function) , but the problem is that the source for the dropdown list has to be merged from the data from sheets pipes and others ( name columns) ... the data should be ordered in the ascending order for better seach ( or even better would be to create a search function that will search a record based on input letters in every dropdown menu - I dont know if something like this is possible in excel )

View Replies!   View Related
How Do I Not Graph A 0 Value On A Line Chart
I have created some charts for my work and one of them is a line chart that spreads across one year with values for each month. Well they want the graph to always show one month ahead of where we are out. So there is actuals in for Sep. but then the line graph drops all the way to 0 for Oct. I don't want to have the graph bottom out when there is a zero. Does anyone know how to fix this?

View Replies!   View Related
Getting Values Off A Trend Line
I have a simple x y scatter graph, to which i have a trend line running through it, fine.

what i need to do is fine some values according to that trend line. e.g. my X axis goes up to 60 and my Y axis goes to 10, so if i draw accross at 55 from the trend line, i then go down to a number on my Y axis.

View Replies!   View Related
R Squared In Line Chart
Hi, as you can see in this chart I am plotting TOTAL company sales against its three merchandise components - men's, women's, and accessories. My issue is that when I had two rows to just show company sales against one of the merchandise categories -- and I Go TO TRENDLINE and show the R-Squared, it is ALWAYS THE SAME= 20%. CLEARLY, something is wrong beacuse (a) its different numbers for each of the three merchandise categories and (b) these three categories make up the total comp so CLEARLY it should be a higher R-squared than 20%. How Can I get it to properly read the R-Square.

View Replies!   View Related
Remove Autoshape Line
I have a shared document I created. In has been in use for 4 months with no problems. This last month, 3 other individuals not very cognizant with Excel were using the document. One of these individuals placed a 'line' in the document. It appears that they used Autoshapes to draw the line.

I want to remove the line they have drawn. It sounds like a simple problem, but I've tried:

* Edit, Clear, All
* Edit, Cut
*Right Click the 'line', Format AutoShape, under Colors and Lines, change Line Color to No Line
* Delete a series of rows with the line in the middle row,

Everything Iíve tried to eliminate this line is not working and this is very frustrating. This type of 'line formatting' is rampant in the department and has appeared in multiple documents, which I've had to recreate.

I'm not sure what they did, so I'm not sure how to correct this issue. I'm presuming they used AutoShapes. There are two small white circles - above and below the line. And a small green circle above the top white circle that has circular arrows surround it....perhaps a rotate feature.

View Replies!   View Related
Straight Line Depreciation
I have a list of items on which I need to calculate the SLD, normally I would just divide the Acq Cost by the Salvage period (5yrs) to calculate the yearly depreciation. However I have been asked to calculate it from the Cap Date, therfore the first year would only be a portion of the year and the final year would also be a potion of the year.

So I'm trying to calculate the depreciation period for an asset with an Acq Cost of £12500 and a Cap Date of 27th July 04 over a 5yr period from that date.

View Replies!   View Related
Selecting A Starting Line
I have a code that print previews a certain amount of rows that I define. This basically says print preview the first 10 lines down.

Can the code be modified so that i can select a start cell. So instead of always starting at A1 I could select say start at G1?

View Replies!   View Related
Find And Replace With A New Line
I want to do a Find and replace a certain character by inserting a line break. I seem to remember that this was possible on older versions of Excel but can't find it now. Anyone know what I need to put in the replace field?

View Replies!   View Related
0 Value On Both X And Y Axis In Line Chart How
i want 0 values to start at x and y axis.
basically i want time in secs on x axis starting a 0 upto 4.4 secs

View Replies!   View Related
Command Line Parameters
How can I get at parameters passed on a command line to Excel 2007?

For example invoking Excel from Vista's Run command with:
"C:ProgramDataMicrosoftWindowsStart MenuProgramsMicrosoft OfficeMicrosoft Office Excel 2007" "C:GZNORPWeather StationParamTest1.xlsm" /e/abc/def

Should reveal the parameters "abc" and "def". But this does not happen!

Supposedly, the API function GetCommandLine does this, but I cannot seem to get it to work. Here's a sample of what I've been trying:

View Replies!   View Related
Formula For The Trend Line.
1. I use a number of x,y pairs
2. From x,y pairs I produce "scatter" type chart
3. From the chart I get trend line and its equation e.g. 5-order polinominal
4. I convert equation into excel formula
5. I apply formula onto the same range of x argument and produce graph
6. The graph is very much different from the trend line!!! I would expect exact match as I use equation/formula for the trend line.

View Replies!   View Related
Copyright © 2005-08, All rights reserved