Excel Crashes When UserForm Reopens After Closed?
May 29, 2013
I have a UserForm appear when the user opens my file. It prompts them to enter some data. If they Close (Terminate) the Window, I have a MsgBox appear telling them they must enter data - and allow them to go back or exit. When they opt to go back the UserForm reapears but Excel freezes and I have to force quit.
Here is the code for my UserForm, including the Sub for when the User clicks OK (CommandButton1) and the Sub for when the User terminates the window:
VB:
Private Sub CommandButton1_Click()
Dim Blank As Integer
Dim Subgroup As Integer [code]....
View 1 Replies
ADVERTISEMENT
Jan 4, 2008
It is a simple form which has a Module/Macro to load the form on clicking a shape.
Although the form works fine for me it occasionally crashes for other user.
The Debug says that there is an error in the Module with the line "frmCallData.Show".
Below is the Code for the form and also the Module: ....
View 6 Replies
View Related
May 4, 2007
I worked really hard on this userform for a work project - my first and likely last attempt at coding!
It used to work, and then I changed a bunch of listboxes to comboboxes, and now my file gives the 'Excel has encountered a problem and needs to close' error - but ONLY when I'm working directly with the excel file and NOT when I've got VBA open.
Compiling shows no problems - I have no idea what to do because this is a very important file for work and I am a very inexperienced coder! ...
View 7 Replies
View Related
Nov 2, 2009
My excel file triggers excel to crash after clicking the only button on my worksheet. The button displays a userform.
However; this does not always happen. It actually drives me crazy as I don't find the solution to my problem. My company were I work upgraded my Excel 2003 SP2 to Excel 2003 SP3 which seemed to help but now the same problem returned...
I found a temporarily workaround though; when saving the file first (right after I opened it) it doesn�t crash when showing the userform. Very strange (to me).
Here is my file: ....
View 6 Replies
View Related
Nov 5, 2009
i have a user form which is activated by a button. when this button is clicked excel crashs every now and then. i get an error message run time error 75, could not find object. it asks me to debug or end. whatever option i choose when i try to save the worksheet there after excel crashs and closes. any body else have this problem, what could be the cause?
View 6 Replies
View Related
Aug 7, 2008
When loading my workbook, my userform loads perfect, but when I go to hit the "next" button. It crashes with the error:
"Path/File access error."
The next button code, quite simple: ....
View 9 Replies
View Related
Oct 23, 2009
I have a userform, every time the user clicks on the start button it recodes there name, today’s date and their start time when they hit finish it records their end time.
The next time the user hits start it will record the users name, today’s date and start time on the next row (below their last entry)
The problem I have is that if the user clicks on start and then does not click on end button, but instead exits excel, then reopens the user form and hits start. The start will go on the row below, but now when they click on the end button the end time will go into the previous row for the end time, as they did not put it in if you know what I mean.
User NameDateStartEndTotal TimeTime InactiveClaire Watts
23/10/0915:04:2515:04:420:00:170:00:17Claire Watts
23/10/0915:04:4715:04:540:00:070:00:05Claire Watts
23/10/0915:04:5515:05:060:00:110:00:01Claire Watts
23/10/0915:05:0815:06:100:00:150:00:02Claire Watts
23/10/0915:05:55
#######Claire Watts
23/10/0915:06:18
15:06:18
I want to stop the user from being able to exit excel if they had clicked on start
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Cancel = True
MsgBox "You have clicked on Start and therefore mus Click the End button before you can exit excel.", vbCritical, "Cannot Close"
End Sub
This disables the X in the top right hand corner, I have aready disabled the one in the user form. However the following code does not let the user exit via File and Exit. Is there a way to put an IF statement into this that say if CmdStart has been clicked then the user can not exit, How every if it has not then they can exit.
I have read threads on this forum as well as on others and this does seam to be and issue.
OR is there a way of Hiding the X button that is in the top right hand corner. However this will still allows the user to hit start button and then exit excel, which will continue with the problem.
View 10 Replies
View Related
Mar 25, 2007
I've got a sheet with 5 UserForms (1..5). Whenever I hide one with a command button there is always a piece of code securing that the basic UserForm1 will be shown in the end. But this is only so when the UserForms get hidden with the use of the command buttons. When the user simply closes the UserForms by usign the x sign he ends up with the active sheet and no UserForms present. How can I secure that closing the last active UserForm with the x sign will cause the basic UserForm1 to show up.
View 2 Replies
View Related
Aug 2, 2009
When an Excel document crashes, I get the option to recover the document the next time I open Excel. However, if it is a read-only file, I don't get this option.
Is there any way around this? I usually work in read-only documents, saving my changes to new documents. If the read-only file I'm working in crashes.
View 6 Replies
View Related
Aug 3, 2013
Ok so I have an extensive worksheet that pulls a lot of data from the web, 47 connections to be exact. So on my work computer that runs excel 2007, the data refreshes instantly and I can see all the numbers flying through and changing as the sheets refresh.
However, my personal computer running excel 2010 hangs up with any type of data refresh, not just this sheet in particular. This computer has 8 GB of ram so I don't think that would be the issue?
Does excel 2010 have an issue with data refresh from the web?
View 4 Replies
View Related
Mar 20, 2014
I have developed a model for a client which keeps crashing after being used a few times. The crash is major! Excel shuts down and asks to send an error report.
This can happen after being run anywhere from 3 to 20 times. (Clicking a POST button which transfers items to a "database" type sheet).
I developed the model on a PC using Excel 2010. When this was loaded on a Mac, the user tells me that it happened periodically, and I have seen is occasionally on my PC as well.
However, the workbook has now been loaded on a server, with users across the state of Victoria accessing via Sharepoint - most using Excel 2007. Now it is happening very frequently.
I don't think the macro is at fault, it doesn't go into debug. Excel just seems to GIVE UP.
Have you seen this kind of thing before? Is there a way of "flushing buffers" or something so that Excel can keep working?
I am reluctant to post the model because it is full of personnel details, and is 2.5mb.
View 6 Replies
View Related
Apr 9, 2009
The code below resides in my personal.XLS Module. When I step through the code everything works till it reaches the point in red then I get the pop up that says excel needs to close and asks to send or not to send.
I noticed that if I choose recover my work and restart excel and I look at the code in THISWORKBOOK of the recovered workbook that the code I wanted placed there is there.
Can anyone explain why this is happening? I have the macro's security set to low and a check mark in the trust access to vb projects.
Any Idea's how to fix this?
View 6 Replies
View Related
Oct 31, 2011
I use Excel 2010, 64-bit-version with Windows 7. I have one workbook, where whenever I create a formula that references to one specific sheet, the Excel crashes and cannot be quitted even with Task Manager. I have to restart the whole system.
I do not have any worksheet events in either sheet. This is the same workbook that crashes if all cells are selected from the top-left corner of the worksheet.
I tried by deleting unnecessary COM add-ins but that didn't work.
View 1 Replies
View Related
Dec 20, 2013
The macro does numerous things, including deleting the sheet that was active when it is called. If the sheet is not deleted, there is no crash. Otherwise, Excel crashes as soon as the VBA interpreter hits "Exit Sub". The Excel message is simply "Excel Stopped Working". The macro also saves the workbook before finishing, and the saved workbook opens just fine, but it's unacceptable to have to kill Excel and restart it every time (I am not the main user for this spreadsheet). I'm using Excel 2010 on Windows 7.
View 7 Replies
View Related
Mar 18, 2007
Situation:
At two places in the middle of my code I need to specify a particular variable; usually this is done by some autodection-method, but whenever this fails a userform gets loaded and the user needs to do some clicks which finally specifies that variable.
Problem:
So far my code does NOT wait for the userform (and the user-input), but continues running until it fails, cause that particular variable (see above) had not been initialised with the correct value for this run.
My Question:
How can I force the code to wait until the userform has been closed? Or what other way do you usually solve that problem when wanting to use a userform in mid-code? Below you find the place where I load the User form 'UsrFormSpecifyFormat' ....
View 9 Replies
View Related
Nov 28, 2013
I have 2 excel files (both .xlsx) and in the first file i am creating a reference to cells in the 2nd file using SUMIFS function. The 2nd file has 275,000 rows of data. I can create the formula correctly, however when i save the file, it just crashes every time (says not responding). If i create simple reference (=A275000) then its fine so im not sure what the issue is.
View 1 Replies
View Related
Feb 28, 2012
I have a VBA macro for Excel 2007 below that loops through a workbook and deletes a picture (shape) in a range at the top of each worksheet.
The macro works fine until a cell which contains a seemingly unrelated data validation list on Sheets(1) is changed. The macro then repeatedly trips up with a 'Run-time error 1004 - Application defined or object defined error'.
The cell with the data validation is outside of the range in which the shapes are deleted and does not set any of the variables in the macro.
Sub DeleteLogos()
Dim Count As Integer
Dim NumberOfWorksheets As Integer
Dim Logo As Shape
Dim LogoZone As Range
NumberOfWorksheets = Worksheets.Count
For Count = 1 To NumberOfWorksheets
With Sheets(Count)
[code].....
View 4 Replies
View Related
Sep 17, 2010
Excel 2007 crashing when trying to up date a data source within a pivot table?
View 3 Replies
View Related
Aug 4, 2006
Currently I have a database in an Excel template. After a user creates a new workbook from the template, a macro button on sheet 1 brings up a window (a userform) to allow selection of items from the database sheet. The item selected is entered on sheet 1 by means of VLookup. That works fine, but to edit the database correctly it is necessary to open the template itself. This is not a user-friendly method.
I figure the best way to solve this dilemma is to separate the template from the database. That is, make the database sheet into a workbook. This I've done. Here's the problem: What code is there that links the list box in the userform (of the template) with the closed database workbook? Is it even possible? If a file path type code is required, it may work on my computer, but when I use my template and database on another computer, the code doesn't work.
Another problem, and similar is this: I'd like to be able to have a macro button that opens the database from the new workbook (which was created from the template) in order to edit the database. If having a template seems to be my problem, I must have it since each workbook created from it is a different project.
View 3 Replies
View Related
Apr 26, 2008
Is there code that will take certain data from one Excel sheet to another named file in a different place on the network? Example Copy cell aa47 from "Recent Faxes.xls" that sits in "correspondence" folder. Then paste into cell B25 "Current Documentation.xls" in the "Sales Contacts" folder
View 2 Replies
View Related
Jun 26, 2012
I have two Excel sheets (test-excel-1.xlsx & test-excel-2.xls)The test-excel-2.xls will never be opened. When I update cells in test-excel-1.xlsx and save, I want them to automatically update to the test-excel-2.xls without having to open it. I have tried the "='[test-excel-1.xlsx]Sheet1'!$G$4" but that needs me to open test-excel-2.xlsI also want original values to be pasted in test-excel-2.xls rather than the code (this is later used in another program).
View 6 Replies
View Related
Aug 13, 2014
I have a row of data in Excel 2013 that is roughly as follows :
Cell A2 - Date || B2 - Status || C2 - Description || D2 - Estimate Time || E2 - Comments
Cell B2 is a pick list of statuses --> Open || In Progress || Closed
The conditional rule I want to create is one where if B2 = 'Closed', format the text of the entire row (cell A2 to E2) to turn light blue.
I was successful in doing this --> basically highlighted A2 to E2; conditional formatting; new rule; use formula; $B$2 = "Closed"; format text color blue.
When I do this, now when cell B2 = Closed, the line turns blue.
The issue is I want this condition to apply to row 3, 4, 5, 6, 7 etc ... basically a multi-row list.
I highlight the cells (A2 ~ E2) and then grab the bottom right corner of E2 and drag down 5 rows (creating row for A3 / A4 / A5 / A6 / A7).
The issue is when I set B3 to Closed, nothing happens; likewise for B4 or B5 etc ...
When I set B2 to Closed, it changes itself and all the rows below to light blue.
This used to work in earlier versions of Excel, but I can not see to get this working in 2013.
View 3 Replies
View Related
Mar 7, 2012
I am having a workbook (say a.xlsm) which has value entry fields and some values are given to another workbook (say b.xlsm) which has some sort of calculations and the result is projected back to the book a. most of the time book b will be closed. I am using Excel 2010.
I opened and saw that the result which is calculated and projected from workbook b is not getting updated. I opened the workbook b and saw that the values I have entered in a has not been updated in b. note that I am opening one book at a time and I do click on update links when I am asked.
View 1 Replies
View Related
Feb 28, 2013
I want to write a macro that will copy data from all worksheets of a specified workbook and copy them into a new workbook.
To give some detail, I receive a report each morning containing failed deliveries. I also export a list of failed deliveries from a system (SAP). These reports rarely match so I must compare the two daily. I do this using INDEX and MATCH functions but now my boss wants all the data in a single report so I would like to harness the might of vba to consolodate all the data in one workbook.
The lists of failed deliveries are contained in worksheets marked mon, tue, wed... so I need to search all worksheets for all delivery numbers and copy all of the data into a new book. This becomes complicated because on Monday there is only one tab marked mon, on tuesday there are two (mon & tue), one wednesday there are three and so on.
I have started on some code but I am getting nowhere fast. I have managed to muster an input box which asks for a date (this will be used to search the file path for a file named "failed deliveries & "mm/mm/yyy")
View 3 Replies
View Related
Jan 27, 2012
Anyone know of a way to detect if a cell is blank in a closed workbook?
Here's what I'm trying to do:
=IF(ISBLANK(closed workbook cell reference),NA(),closed workbook cell reference)
also tried:
=IF(closed workbook cell reference="",NA(),closed workbook cell reference)
Neither one worked. I'm using Excel 2007.
View 8 Replies
View Related
Nov 19, 2008
I have 1000 workbooks in a folder, each workbooks format is same.
as of now I open each workbook, and check if values in A10 is equal to B10, that is if the value in A10 is "100" I will check if B10 is also "100" if not I will make a note the file name.
I have more than 1000 workbooks in a folder, It is really difficult to open and check if the values are same. is there a macro, which will check the condition A10 = B10, if not get the file name in one sheet.
View 9 Replies
View Related
Apr 14, 2009
I have the following code which filters data in a sheet, and loads the numbers into textboxes on a userform. There are two multipage controls, each with several textboxes on them. I have commented out several lines because if I leave any of them in, it crashes excel.
It will work once. But if I close the workbook, re-open it, and run the code again, it crashes.
The thing I find really interesting is that all the 'problem lines' were added in as part of a retro-fit. The person I created this workbook for needed one more column of data. I followed the same programming pattern as what I used on the other, but only these ones seem to cause problems. Any thoughts?
NOTE: The message boxes were just to help me figure out which lines of code were causing the crash. ....
View 9 Replies
View Related
Mar 5, 2007
My main workbook basically starts with, Sub macro1 (), Do Until, Web Query, many many many calculations in between and finally ActiveWorbook.Save.
After ActiveWorbook.Save it will start the same process with a new web query and works all perfectly and perpetually just as I would like it to....
View 9 Replies
View Related
May 14, 2007
I'm trying to use a listbox and wanted to have the data sit in a different sheet. When I do this, I get a message about low memory and then excel says it has an error and shuts down. When I move the data to the same sheet as the listbox, there is no problem.
I'm using excel 2000 and that's all I can get (at work). Any thoughts? Should I just put the data on the same sheet and hide it? Is there a way around this?
View 9 Replies
View Related
Oct 19, 2007
Just recently Excel crashes about 4 out of 5 times. Any advice to where I should start looking and how to handle this please?
View 7 Replies
View Related
