New answers tagged vba
0
There is no single built-in Excel function to achieve what you require. Either string together some sorting, moving and simple built-in functions if a once-off requirement - which I take it you would be quite capable of achieving without help - or use VBA.
The inference is either that you have a lot of entries (though that would make little difference to a ...
0
Alright, just a misunderstanding. In the code segment of the userform you don't need its name to initialize. A simple Private Sub UserForm_Initializee() is enough. You can disregard its name completely.
0
This assumes you are naming your sheets as stated in your question and the new sheet is active. You will add this code to the end of your existing code. It will create a formula to calculate the cumulative value you seek. When the user enters or changes a value in the number of incidents, it will update.
Dim intLast
Dim strSheet As String
'Get name of ...
3
What you are looking for is Excel's Personal Macro Workbook function, which allows you to store your frequently used macros in a special hidden workbook that makes them available in any workbooks you have open.
Here's how it works.
0
In short answer to your question, you can manipulate labels through VBA, but I think you'll have a difficult time creating an efficient algorithm to cleanly place labels on a continually changing pie chart.
I'll suggest an alternative to the pie chart (they're really not a great charting alternative, here's a place to start looking if you're curious Save ...
1
What you've given is a formula. VBA doesn't use formula syntax like we would enter into a cell.
You will need to use the IF...[condition]...THEN...[do this]...ELSE...[do this] with a check for Null, which is how Excel looks to see the cell is empty.
If Range("P7").Value = Null Then
Range("N7").Select
Else
Range("M7").Select
End If
Here is more ...
1
I did some browsing and obtained the way to get the polynomials for the second order equation
Mpolynomials = Application.WorksheetFunction.LinEst(RangeM, Application.Power(RangeF, Array(1, 2)))
Here Mpolynomials is a Variant
0
I finally got the autofilter working. The following is what I used:
With shSource
LR = .Cells(rows.Count, "B").End(xlUp).Row 'Last row of column B
.AutoFilterMode = False
With .Range("B11:BQ" & LR)
.AutoFilter Field:=colNum, Criteria1:=">=" & minValue, Operator:=xlAnd, Criteria2:="<=" & maxValue, ...
0
I was misunderstanding you.
You want to use
Dim str As String
str = Range("a12").CurrentRegion.Address
Range(str).AutoFilter
'or
Range("A12").CurrentRegion.AutoFilter
this will filter the entire region that those cells are in.
Alternatively, you could use something like (if there are missing cells or holes this might be useful).
Dim str As String
str ...
3
Move the code to the ThisWorkbook page
and change the event to the Workbook_SheetChange event.
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Set KeyCells = Range("C9")
Set isect = Application.Intersect(KeyCells, Range(Target.Address))
If Not isect Is Nothing Then
Application.EnableEvents = False
...
0
Since you did not specify
What type of email is setup in Outlook (POP3, IMAP, Exchange and Outlook Connector)
Here is one solution:
For Outlook 2007
Go to Tools > Options
Go To Calendar Options > Resource Scheduling
Check the box – “Automatically Decline Conflicting Meeting Requests“
Additionally, you can also check the box, optional, – ...
1
You can simply send the forumla as a string. Below is an example.
Range("C2527").Value = "=MATCH(TRUE,INDEX($C2531:$C2731 < 1,0),0)"
2
As far as I understand, your are using the intersection operator (space) in your INDEX formula: "$C2531:$C2731 <1". This will compare every cell between in one range ($C2531$C2731) against another range, but in this case a "<1" comparison instead. So the Intersection will return a range containing a TRUE or FALSE value for each comparison (ie. an array ...
0
Odd, when the question migrated over from SO, my first comment with the link was deleted. Here it is again:
How can I use custom colours in the Microsoft VBA editor?
Since you're manually changing everything, my only other suggestion is to make sure you don't accidentally make some highlighting color invisible against your new background.
Top 50 recent answers are included
