Closed Thread
Results 1 to 2 of 2

Type into a cell in Excel 2010 (one with UserForm, vba, several sheets) and Excel crashes

  1. #1
    Registered User
    Join Date
    01-28-2014
    Location
    Manassas, VA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Type into a cell in Excel 2010 (one with UserForm, vba, several sheets) and Excel crashes

    Greetings!

    This is my first time posting in this forum. I have already said a silent prayer that assistance to my particular problem may be found here.

    Well, as the title states, I have an Excel 2010 workbook and, on one of the sheets, whenever I attempt to type in a cell, Excel crashes. I have never heard of such an annoying symptom before (I admit my irritation is heightened a bit due to the fact that about 10 analysts are depending on me to finish a user friendly app ASAP.

    Specs:
    > 15 sheets in the spreadsheet. Current size is 127 kb
    > has a userform with 13 tabs in a multipage userform
    > each sheet has at most 120 rows, and at most 15 columns
    > probably 110 defined names or so
    > sheet uses Excel vba (in the userform) and runs light sql statements when the form is loaded

    If you would like to see the behavior in action, open the attached ICRP_dev_v4.xlsm in Excel 2010 and, in the sheet entitled ReviewerNoteResize, attempt to enter values anywhere in the A103:E110 range. You will (if you're like me) encounter Excel crashing for no apparent reason.

    Tried but results unsuccessful:
    > Searched the forum looking for answers - no joy
    > Did a File Open, then selected Open and Repair, and chose the repair option - still didn't correct problem.
    > Error was occurring on my notebook computer. I then tried the spreadsheet on my desktop PC - same crashing annoyance.

    Thanks in advance for any assistance you can offer!

    Regards,
    - Dave,
    Attached Files Attached Files
    Last edited by Fotis1991; 02-24-2014 at 03:16 AM.

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Type into a cell in Excel 2010 (one with UserForm, vba, several sheets) and Excel cras

    Thread closed as Op posted in Commercial Services Sub Forum.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 10-21-2013, 02:55 PM
  2. Code works in Windows excel 2003 and 2010 but crashes in Mac excel 2011
    By kiweed in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2012, 08:46 PM
  3. MS Excel 2010 crashes
    By Richard_G in forum Excel General
    Replies: 0
    Last Post: 07-11-2011, 08:57 AM
  4. MS Excel 2010 crashes
    By Richard_G in forum Excel General
    Replies: 1
    Last Post: 06-25-2011, 12:18 PM
  5. Code Crashes Excel 2010 but works in Excel 2003
    By aaronf316 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-07-2011, 03:46 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1