I have a matrix that calculate lenght of the sides in a triangle, this is for the purpose of a camera and the pixelsize/inchsize.
Is it possible to create a chart that will give the user an visual control on how the cameras detection area looks like?
I am new to Excel VBA - Normally, If u move your cursors to the corner of your userform,we will see the single-two pointed arrow pop-out and then we can adjust our own desired size of the user-form.
How to do that in EXCEL VBA?
Is there a way to adjust the font size in a comment. The default seems way to small. All thoughts on the subject .
View 4 Replies View RelatedI would like excel to adjust to a certain size when the program is opened using vba. Not to equal the computer monitor size but only the size i choose (as it is almost square).
View 3 Replies View RelatedI frequently have to copy information from one excel sheet and paste it into another. But when I do this the formatting doesn't carry over. So I have to go to each individual cell that I pasted into and adjust the size of it. How do I copy and paste so that the formatting/cell size is preserved?
View 4 Replies View Relatedhow do i print on a3 paper? i can't find the option anywhere...i can select user define size but then where do i define it?!? i know this is a silly questions
View 3 Replies View RelatedI'm trying to come up with a histogram chart that adjusts Bin Size based on user input. I've come up with the formulas for Bins and Frequency, but am struggling when it comes to charting the data to dynamically update when the user changes Bin Size. How to make the x-axis dynamically adjust with the number of Bins.
View 5 Replies View RelatedI have a worksheet with 30,000 rows. But sometimes even if I have fewer records in this worksheet(lets say 1000) worksheet shows the same 30,000 rows.And its annoying when you try to navigate using vertical scroll bar. Is there any option to re-adjust the worksheet to make it more user friendly based on number of rows in current sheet.
View 2 Replies View RelatedIn the attached file, there are three sheets: Data and Private. Sheet Data contains data source. I want to try to covert the data in sheet Data into Private in triangle format.
For example, Sheet Data range A1:A5 will be converted into the latest diagonal in sheet Private range A1:E5.
Sheet data range D2:D5 will be converted into the second latest diagonal in sheet Private range A1:E5.
Sheet data range G3:G5 will be converted into the third latest diagonal in sheet Private range A1:E5.
Just follow the step, there will be a triangle range A1:E5 in Private. Same thing, there will be another triangle in Private.
During the past few years, I use an Offset/Row/Column formula to create a triangle. I feel code can do the same thing because the data structure follows a kind of pattern. I tried and failed.
I am a novice user and not very familiar with Macros or VBA. I took a macro I found on contextures and got it to resize comments that already exist. However, I am trying to get it to also create the comment (with no content) if the comment does not already exist, and then resize it. This is what I have so far:
Code:
Sub ResizeCommentsInSelection()
Dim mycell As Range
Dim myRng As Range
Dim lArea As Long
Set myRng = Selection
[code].....
I have a user form on which I need to create a textbox every time the user clicks a button. There are too many to create them all in advance and make them visible when needed. The sample attached, from this forum, is good, except, the numbers in the text box just scroll along and I need to see all the text typed into my textboxes. I would like the textboxes to be multiline, wordwrap and have them resize according to the amount of text.
View 6 Replies View RelatedSheet1, there have data in A1 (100);
Sheet2, there have data in A1 (200) and A2 (300);
Sheet3, there have data in A1 (400), A2 (500), A3 (600);
Sheet4, there have data in A1(700), A2(800), A3(900) and A4(1000).
Now I want to use For Loop code to copy the data in Sheet1 through Sheet4 and paste them in Sheet 5 beginning with A1 into a triangle format:
100 300 600 1000
200 500 900
400 800
700
I am trying to put together multiple userforms that perform separate tasks. I have been using code found on this forum, and it's helped out a lot, but i'm still having trouble on one of the userforms. the one that i'm having the biggest trouble with called frmEditData. What it is designed to do is pull data from different fields and display them in the textboxes on the different sheets. then, the user has the option of updating those tabs and saving the changes. For the life of me, i cannot get the data to change. it always reverts back to the original information in the cells.
i have to say again that I don't really know how to read the code too well just yet, and i've been copying code that appears to work on other sheets, but it might not necessarily work here. I have attached a rough copy of what i've been working on.
I am looking to identify when
a) New comments are entered in cells
b) When changes are made to existing comments
c) New cell entries
d) Changes to existing cell entries
I have mocked up a typical example between sheet 1 and 2. I have found tools that will identify cell entry changes (i.e. c & d) but not on cell comment changes (i.e. a & b).
I have a userform, on it is a very large command button with a picture of a map loaded on the button. The button is 500 width(X) by 500 height (Y), so the center of the button would be at the location 250 (X) by 250 (Y). The button is coded for mousemove to get the X,Y cooridates and when you _Click the button a textbox gives the distance to the point(mousemove) from the center of the button. All that is good, but now I'd like to find the degree of the point referenced to a compass, ie, if the point is at 250 (X) and (Y) is less than 250 then the point would be due north at 0/360 degrees and if the point (Y) is greater than 250, it would be south of the center of the button. I hope this make sense. It's been a long time since trig. I've been searching but can't seem to find the correct formula to figure this out.
Here's the other problem, I'm doing this in powerpoint so I'm not sure if cos or tan functions are loaded in this program. I am posting this in the xl forum because I figure that's where most of the people who could figure this out are. If this is in the incorrect forum I can try to move it,
I have a spreadsheet with the following headings:
A
Claims Number
B
Name
C
Scheme
D
Admin
E
Date
I need to create a user form that will "pop up" and ask the administrator to enter the above details.
A - should be created automatically (ie last claim number + 1)
B - user enters manually
C - data retrieved from a list
D - data retrieved from a list
E - date is the date the information is entered
Some of the sheets in my spreadsheet contain some data and graphs with a few macros that are run when a button is pressed. At the bottom I have some comments with a macro that is run to timestamp when these comments are updated or edited.
What I would like to do is lock the entire sheet so that the data and graphs can't be tampered with, apart from the comments part at the bottom because I'd like to be able to have the comments editable. So far I have managed to do that, but when I edit a comment and the timestamp code is run it creates a run-time error 1004. I could just remove the timestamp code I guess but I'd like to keep it there... figuring that there must be a solution.
How can I work around this problem ? Either by being able to keep the sheet locked and still have the timestamp code run, or have it temporarily unlock the sheet - run the code - and then re-lock the sheet.
I have a 22x22 matrix with correlations; I want to extract the lower traingle as a single row; so my matrix is
# r1 r2 r3 r4 r5 etc
r1 1 0.5 0.3 0.7 etc
r2 0.5 1.0 0.5 etc
r3 0.3 0.5 1.0 etc
r4
r5
etc
I want my row to be
r11 r12 r13 r14...r1-22 r21 r23 r24 etc..
I need to write a spread sheet that will calculate the length of 2 unknown sides of a right triangle using the following information.
Here is what I know
1. I have a right triangle
2. I know the length of the hypotenuses
3. I know the ratio between the length of the other 2 sides
I need to write and Excel file that will solve for the length of the other two sides
The math look like a^2+b^2=c^2
with c being known and the ratio between a and b known
When I click this button, a new row is inserted. Depending on whether this checkbox is checked, I want some of the formulas to adjust.
Public Sub AddEntry()
thisone = ActiveSheet. Name
FinalRow = Range("A65536").End(xlUp).Row
Range("A" & FinalRow + 1).Select
Selection.EntireRow.Insert 'just inserted a new row
x = Range("T1").Value
Sheets("Calculator").Select
Rows(x + 3).Select
Selection.Copy
Sheets(thisone).Select
Rows(FinalRow + 1).Select...........................
I sent an excel file to a friend. When they opened the file a half triangle mark appears in any cell where there is a formula. How do i get rid of this mark?
View 3 Replies View RelatedI want to concatenate two Cells into a single cell BUT have the first field left justified and the second cell right adjusted.
A1 = "John Williams", A2= "Single"
A3 = "John Williams Single"
I have the following formula to calculate the angle a connecting rod of a piston should be
P3 is the length of the crank
P4 is the length of the connecting rod
and K42 is the angle of the crank
=PI()-ASIN(P3*SIN(K42)/P4)
Whats the purpose of taking pie away at the start?
I have a list of 3D landmarks, and I'm trying to calculate angles and distances between specific combinations of these points.I hit a complete wall when trying to use excel to calculate out those equations. way input these equations?
Distance equation --> distance between points A and B = sqr root of [(Ax-Bx)^2 + (Ay-By)^2 + (Az-Bz)^2]
This person (see the link) posted the excel equation, and I spent a long time trying to follow it, but can't make sense of it! [URL]
I have attached a summary of the excel I have, and exactly what I'm trying to calculate.
Summary:
1. What is the excel equation to calculate the distance between two 3D coordinates (x,y,z)?
2. What is the excel equation to calculate the angle formed by 3 3D points (again, with x,y,z coordinates)?
I'm attempting to calculate the bearing of a vector linking two sets of Easting/Northing coordinates and while I've found no shortage of equations online that should provide an answer, none seem to work in my excel sheet. The data comes from the southeastern hemisphere (i.e. Outback Australia) and my answer is needed in degrees to true north.
View 6 Replies View Related1. I dont want this to auto send. I want it to compose the mail and leave it ready to hit the send button in lotus notes. How do I do that?
2. Would like to include multiple emails. If I put two emails (separated by comma or semicolon into cell C19, Lotus notes sends as one address and it bounces. (This is not terribly important, but would be a nice feature)
3. Would like to insert the signature line that's already configured on lotus notes. Since this auto sends the email, the signature is not added. Any idea how to do this?
4. Now this would be really nice, tell the macro which database to use. The one I want to use is not "my" email, but a shared email. It lives on server "Notes1/recovery" , in folder "mail" with a database named "company.nsf". Is there a way to do this?
Here is my code that works, but needs the above features.
Sub SendNotesMail()
Dim Maildb As Object
Dim UserName As String
Dim MailDbName As String
Dim MailDoc As Object
Dim Session As Object
Dim Recipient As String
Dim Subject1 As String
Dim ccRecipient As String
how to rotate a object in excel, by typing the rotation angle in excel.
View 1 Replies View Relatedi was set some work related to maths to be carried out in VBA. the problem for me is im finding it very hard to understand either and so i cannot seem to work out how to complete the assignment given.
i can attach the assignment to save space and time reading on here however if you would like me to post up the assignement i can do that too....
How to plot circles via vb. Basically I would like to plot circles on the vertices of a triangle with the following data.
1) length a = 69, b=103, c=119.9967, angle between a and b =86.1. (These values are determined from the cosine rule)
2) Diameter D1=40,D2=98, D3=108
See link of circles : IMAG0176.jpg
Is there a way to add comment text at a 45 degree angle to an excel chat?
What I need to do is to add a comment parallel to a 45 degree line on an excel chart, and the text box dosen't give you the option t have 45 degree text.