Giving Back Focus
May 10, 2007
I've got a Macro that generates three reports for me, one at a time.
After a report has been generated it creates an Email and attachs the report to the Email, I then check the report is ok before sending out.
The problem is, that once the first Email has been generated Excel is pushed into the background and the macro sloooooooows down.
I believe (though I will quite happily be wrong) this is because Excel is no longer the PC's main concern.
What I was wondering was, is it possible to bring Excel back to the foreground once the Email has been generated.
View 9 Replies
ADVERTISEMENT
Nov 11, 2009
I have a userform, when using the form it has focus, once I click on my "Ok" command button I want to return focus to the workbook while I leave the userform open. I already have the userform open and on top of the workbook.
View 2 Replies
View Related
Oct 24, 2012
Code:
Private Sub ComboBox1_Change()
ActiveCell = Me.ComboBox1.Value
End Sub
How do I get focus back to the sheet or cell instead of the ComboBox ?
View 1 Replies
View Related
Aug 1, 2008
I call a userform (modeless), and then i'm trying to set the focus back on the range that was selected when i showed the userform. you would think i could just define the range and then use rnge.select like this....
set prevrnge = selection
UF.show (vbmodeless)
prevrnge.select
but it doesn't take the focus off the userform....
View 9 Replies
View Related
Feb 18, 2009
I'm working on a spreadhseet which has several macros that can take up to 5 minutes to run. When the macro(s) complete, I pop up a userform to provide instructions and collect some additional data from the user.
The "problem" is that when the user moves to another application to do other work, the user form remains hidden behind the active app. I've added some text to the status bar to let the users know the processing is done, but they would like something more obvious - so, is there any way I can force focus back to Excel?
View 2 Replies
View Related
Aug 11, 2012
I have a layout something like the following:
A1
A2
A3
[Code]....
Where each (i.e., A1) represents a location. I have tried to use a coordinate system but this will not work for the back-to-back locations. (Assuming each location is 2 feet wide, For example A1 to C1 is 4 feet apart, not 2 feet (as Euclidean or rectilinear would calculate it as).
Would there be a way to incorporate an if statement for those locations that are back-to-back? As a rectilinear distance calculation would work as long as the locations are not part of the same "block".
Ultimately I am looking to have a matrix which contains all the distances between each location:
A1
A2
A3
B1
[Code].....
View 4 Replies
View Related
Dec 13, 2006
I must be using hte wrong command or I am dumb.
Cell B8 I have a validation list of either Hub, Router, N/A
On cell C8 I want if (B8=Hub,3COM,0) but I get a NAME error. Is it because it won't work with letters but it can make the calculation?
View 9 Replies
View Related
Oct 14, 2009
IM USING VLOOKUP TO FIND a VALUE IN AN ADJACENT CELL, BUT IF THE VALUE ISNT LISTED THEN I WANT IT TO DO NOTHING. EXAMPLE
=VLOOKUP(1100,Tuesday!A:F,6)
BUT IF THERE IS NO 1100 TO LOOKUP THEN GIVE ME A 0 VALUE OR DO NOTHING
View 3 Replies
View Related
Jun 19, 2008
Sub testDateCompare()
Dim nmiDate As String
nmiDate = CDate("23/4/08")
Dim origDate As String
origDate = CDate("23/04/2008 15:05")
origDate = Left(origDate, InStr(origDate, " "))
Dim minDate As String
minDate = WorksheetFunction.Min(origDate, nmiDate)
MsgBox minDate
End Sub
Giving '400' error!?
View 9 Replies
View Related
Apr 2, 2014
I'm working on a spreadsheet and I want the letter "E" to have a numerical value of zero, and not necessarily in just place as my sheet will be regularly updated. If you're a fan of golf, you will understand what I am doing. I'm basically making a custom leader board for a fantasy golf game that I'm doing, and I'd like for the letter E to represent the value of zero when I am adding up the scores.
For example
A1: -1
A2: -3
A3: 4
A4: E
A5: -2
A6: 3
A7: 3
A8: -5
Total: -11 (have a formula set up to only count the best 4 scores).
I want to be able to add up those columns, and since only the lowest 4 scores count, I need E to equal zero. I get that I could just put 0 there, so I'm being a little picky (in golf E represents Even par, essentially a value of zero for the purposes of this game). There are 20+ teams in the game so I need E to be recognized as zero in each of those fields.
View 14 Replies
View Related
May 12, 2006
Sheet 1 has 3 columns: grade, step, NBS
Sheet 2 has 3 columns: SM, grade, step
I want to add a column NBS to sheet 2 for that exact grade and step, from
the data on sheet 1.
I tried the following formula but it gives me #value!.
=INDEX(sheet1!$C$2:$C$6,MATCH(B2&C2,sheet1!$A$2:$A$6&sheet1!$B$2:$B$6,0),3)
View 9 Replies
View Related
Mar 22, 2009
This formula has been working fine for me...until I have the condition where no value >0 has been entered in my LOOKUP range as yet. Or at least that is what I have managed to test so far. I've verified that my values have the same format (General) and I've verified that my ranges are all of the same size.
I'm looking in one worksheet for a work order meter reading that will be entered in another sheet when the Unit # for the equipment matches. I discovered if there is a work order entered for and no meter reading has ever been recorded yet, I get the #N/A error. If I go in and put a fictitious meter reading in of 1, the error goes away. It doesn't like a blank or zero meter reading and I need to know how to get around this. Here's the current calculation:
View 2 Replies
View Related
Aug 7, 2009
I referred the above two articles and accordingly created Personal.xls file in XLSTART folder. Here is the screenshot: http://dl.getdropbox.com/u/872430/excel.png I have done nothing else to the workbook except what is seen in the screenshot.
I have tested the funtion by using it as a formula in the Personal.xls file.
When I start Excel, Personal.xls does start up but the funtion is not available to my in my other workbooks. Is there anything that I have missed out?
View 4 Replies
View Related
Feb 4, 2013
I have a very large excel spreadsheet with many formulas in it. Some of the formulas are giving a 0.00 value even when there should be a $value. I don't know why this is happening? It is not happening to every formula and it is not consistant within the same row or even the same column. Most of these formuals have been used in this spreadsheet for years by many different people with no problems.
View 4 Replies
View Related
Apr 11, 2013
I noticed that when I clicked F4 Button on the keyboard it shows the screen resolution(with screen 1 and screen 2) as though one wants to use projector. The keyboard's configurations seems different from what I am used to.
What I can do to resolve this as I wanted to use the F4 Button referencing($).
View 6 Replies
View Related
Jan 24, 2007
I have a problem with isnumber giving me two different results. One time it will evaluate the following as true:
ISNUMBER(0)
and in the same sheet it will evaluate the same as false.
I need ISNUMBER to NOT recognise "0" as a number all the time.
View 9 Replies
View Related
Feb 4, 2009
I have a CSE formula that's been working great since day one.
In B202 I have the name Magnecraft.
In Row9 I have all the possible sources for this item starting in D9:CB9.
The fx in C202 is as follows:
{=SUBSTITUTE(MCONCAT(IF(INDEX(D202:CC202,MATCH(B202,B202:B202,0),0)="X",","&$D$9:$CB$9,"")),",","",1)}
I have an "x" in E202 and I202.
C202 should then show (in this case) Abacus and A/E as the 2 sources available.
I'm getting an #NAME? error.
And if I insert a new row, all the data in each cell in C"C turns to #NAME?.
View 9 Replies
View Related
Feb 26, 2009
I was looking at the other posts and this should work. Why the bleep can't I get the MROUND function to work. Simple scenario...I need to round UP numbers to the nearest 50. 320 should bring back 350, 351 should bring back 400.
For example, if this is in cell A1, I think the formula should be =MROUND(A1,50). Yet everytime I use the function, it gives me NAME#.
View 11 Replies
View Related
Feb 25, 2014
Cell A3 on my SHEET1 has the following formula =DATE(YEAR(C1),MONTH(C1) + 1,DAY(C1). It goes on like this for the next 12 months (+2, +3, +4....).
Column B on my SHEET2 has One of the five product codes (A, B, C, D, E) and Column D on my SHEET2 has manually entered dates
I created the following condition for each product code under each month in SHEET1
=IF(MONTH(Sheet2!$D$1:$D$39)=MONTH(Sheet1!$A$3),COUNTIF(SHEET2!$B$2:$B$39,"=A"),"")
The formula only works for two product codes (A and B), and then yields blank cells.
View 5 Replies
View Related
Mar 23, 2014
I need to find the which two columns that give the greatest combination.
Row 2 shows some possible combinations, a total of combinations is 21.
Attached File : test.151515.xlsx
View 12 Replies
View Related
Mar 24, 2014
I have a fomula field in row 67 and 68 .Row 67 calculates the average and row 68 calculates the improvement i.e. average(row 68)- last row inserted(row 67). The values for improvements are not showing correct value. C68 seems to give correct value but B68 and D68 is giving wrong value.
B68=4.8-4.5 =0.3 but it shows 0.4
C68=14.9-15.1=-0.2
D68=11.3-10.2=1.1 but it shows 1.0
I have attached the sheet also.
Sheet 1.xlsx
View 11 Replies
View Related
Jan 8, 2009
I am making a company wide estimate sheet and having trouble with the drop down box. I have a drop down to pick the branch, but when I name the source it only says branch, even though I named the data on the branch sheet. I would like to be able to pick the branch initials and have it populate the phone and fax number under the main heading but am getting a error there.
Also for the labor is it possible to have it insert the correct labor into the formulas at the labor lines according to which branch is picked from the drop down.
View 4 Replies
View Related
Jul 30, 2013
Find enclosed a chart wherein there is a super user of a particular system under him there are 5 users (can get increased also), now every user including super user is having a specific function to perform and a specific area to operate. i want to give a separate hyperlink to every user for describing his role & responsibilities and to list his dos and donots.
Sample.xlsx
View 1 Replies
View Related
Aug 15, 2014
how to give attractive colours to my ordinary macro buttons to which we assign macros
View 2 Replies
View Related
Jun 5, 2012
So I am using a macro to do a particular task. Part of the macro's process is to delete some unwanted rows.
The code below was for my original macro which works absolutely fine:
Note: The ranges are fixed (i.e. column "AT" is reffered)
Code:
Sheets(1).Select
Dim Current As Worksheet
Dim Flt As String
Flt = Me.TextBox2.Value
For Each Current In Worksheets
With Current
With .Columns("AT")
.AutoFilter field:=1, Criteria1:="
View 3 Replies
View Related
Mar 24, 2014
I have a fomula field in row 67 and 68 .Row 67 calculates the average and row 68 calculates the improvement i.e. average(row 68)- last row inserted(row 67). The values for improvements are not showing correct value. C68 seems to give correct value but B68 and D68 is giving wrong value.
B68=4.8-4.5 =0.3 but it shows 0.4
C68=14.9-15.1=-0.2
D68=11.3-10.2=1.1 but it shows 1.0
I have attached the sheet also.
Sheet 1.xlsx - Speedy Share - upload your files here
View 2 Replies
View Related
Feb 9, 2007
I am using VB6 to automate excel. Ofcourse, the code needs to work with 2007 and all lower levels. When trying to save the excel doc in 2007 I get no errors. However, in 2000 (using the same code) I am unable to save my document.
Here is the
OfficeDoc.SaveAs FileName:=NewFileName, FileFormat:=FileFormatValue
It fails with error 1004: application-define or object-defined error.
I have checked to make sure no other office documents are running in the background under task manager.
View 9 Replies
View Related
Apr 2, 2009
I have the following code which copies specified cells from one sheet to the next available row on another sheet. I would like to keep the next available row somewhere near center focus on the display. Can I use the variable 1Row to do this, or maybe 1Row plus or minus 20 depending on how I want it displayed on the screen?
View 2 Replies
View Related
Feb 20, 2009
I have a workbook with calculations for a sale less the assorted fees and at the end giving the final amount from a sale.
I have noticed that some of the rows are not giving the correct amount in them.
In other words the addition of some columns in that row are not adding up correctly. It is only off by 1 cent (either over or under), but I can't figure out why.
I have the feeling that I am going to want to kick myself when someone explains this to me (I just know that I know the answer but for the life of me I can't right now).
View 2 Replies
View Related
Dec 20, 2009
I have a formula that is correct all the way up to adding the last *K9. here is an
example:
C9 a number 4 then add 1 to it which makes it 2 now * it by D9 which is the number 384 and the answer is 768 now * that by K9 which is 6 and you get 4608 I'm getting 2310 using this formula... =IF( C9=0, 0, C9+1*D9)*K9.
View 3 Replies
View Related
