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

**baiken315** · 12-22-2016, 02:15 PM

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.

**mehmetcik** · 12-22-2016, 02:51 PM

Hello

you have not used the Kiss principle when creating your Userforms.

[ Kiss = Keep It Simple Stupid ].

In the deposit form, There are 6 options

Programme Areas 1 to 5 and restricted.

So why not use 6 buttons?

**baiken315** · 12-22-2016, 05:13 PM

I can appreciate the KISS principle, but I'm not certain 6 buttons accomplishes any more simplicity. All of my combo-boxes need to pull from existing options for the drop-down, but also allow-free entry in the case the user is adding a new program area, etc. Each deposit entry should contain data for each field (with a few exceptions for notes, etc.) but I view that as a single submittal, not 6 different submittals.

**mehmetcik** · 12-22-2016, 05:19 PM

Bear with me

I am working with it.

Ok I played around with your first three inputs.

I would swap the first and second inputs around if I were you.

Ok I had a lot of issues interfacing the Datepicker with your Deposit userform. Sorted now.