Results 1 to 5 of 5

Userform slow to enter data - event handling issue (I think)

Threaded View

  1. #1
    Registered User
    Join Date
    12-22-2016
    Location
    Alexandria, Virginia
    MS-Off Ver
    2016
    Posts
    3

    Userform slow to enter data - event handling issue (I think)

    I'm not smart enough to get to the root of this myself. I'm fairly certain this an event handling issue and I need to suppress events as part of my userform, and I've read http://www.cpearson.com/Excel/SuppressChangeInForms.htm, but I can't figure out how to apply that solution to my sheet.

    All three of my userforms in the attached sheet are frankly quite slow. I'm pretty sure this has to do with my use of dynamic named ranges in populating the drop-downs in the combo-boxes, but again I can't figure out how to avoid this slowing the form down to a crawl when hitting submit.
    Last edited by baiken315; 12-29-2016 at 12:56 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 02-27-2014, 04:43 PM
  2. [SOLVED] Excel VBA event handling
    By vangxbg in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-06-2013, 03:25 PM
  3. Excel Refreshing Data from Web special character handling issue
    By dkhunt27 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-22-2012, 05:30 PM
  4. [SOLVED] VBA, MultiPage with UserForm. Syntax issue. mousemove event.
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-22-2012, 01:59 PM
  5. userform event handling within a standard code module?
    By jerseyguy1996 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-07-2010, 01:01 PM
  6. event handling froma userform
    By jad70 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-10-2009, 09:15 AM
  7. [SOLVED] MsgBox in Enter event causes combobox not to run Change event
    By Richard in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-06-2006, 10:55 AM
  8. [SOLVED] Event handling...
    By Alex in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-29-2005, 03:14 PM

Tags for this Thread

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