+ Reply to Thread
Results 1 to 3 of 3

Editing UserForm Workbook Crashes

  1. #1
    Forum Contributor
    Join Date
    09-29-2014
    Location
    Montreal, Canada
    MS-Off Ver
    2013
    Posts
    222

    Editing UserForm Workbook Crashes

    My workbook consists of 1 sheet with about 1400 records and a userform with controls to access / edit these records. The userform works very well

    I want to revise the layout of the userform and I made a copy to do the changes on the copy first but as soon as I try to re arrange some controls (texbox / labels) Excel (2013) crashes and have to start over again. The copy I made is in another directory with the same file name which after a few crashes a change the file name but the problem persist

    Am I doing something wrong?

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,168

    Re: Editing UserForm Workbook Crashes

    Hi Oscar,

    I'd make a copy of the whole workbook as a backup and try to edit the original and only userform. There are a lot of things that might go wrong as the order of the controls on the userform might be important. There is also CODE behind userforms that might not like what you are doing and crash. We really need a sample workbook with the userform and some data to see what might be crashing.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Contributor
    Join Date
    09-29-2014
    Location
    Montreal, Canada
    MS-Off Ver
    2013
    Posts
    222

    Re: Editing UserForm Workbook Crashes

    Thanks MarvinP for the help. Copy of my workbook is located here at post #4

    http://www.excelforum.com/excel-prog...l-control.html

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Populating a userform from a search button and editing the workbook
    By jonesdwj in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-16-2013, 01:55 AM
  2. Excel Crashes when testing userform
    By Magnet in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-27-2012, 08:54 AM
  3. UserForm crashes excel if workbook is shared
    By techteam in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-03-2012, 09:09 AM
  4. Excel2007 crashes when editing connection properties
    By tronix in forum Excel General
    Replies: 0
    Last Post: 09-25-2008, 09:58 AM
  5. Excel Crashes when saving after running Userform
    By jjking57 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-10-2007, 12:43 PM

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