Form takes a long time to open

I also have attached it so you can view. This form is not large, but it seems to take awhile to open, can someone look at the code and tell me if something in the code is causing this?

Please Login or Register  to view this content.

Also, where would you put code to add a calendar drop down, if that is possible?

Your one named range is 65536 rows long.

Use this to populate the Line Lead ComboBox

Please Login or Register  to view this content.

Right click on the Tool Box,select add additional controls, see if You can find Microsoft Date and Time Picker. Click it to add to your tool box.

I wouldn't use the DatePicker control, it can be problematical - it's not always available on other users'PCs & from Office 2010 it is no longer available.

See the alternatives herehttp://excel-it.com/free_addins.htm, I generally recommend the ComboBox example

replace

Please Login or Register  to view this content.

With this

Please Login or Register  to view this content.

Originally Posted by 00Able

where do I place that at in the code? Also I have microsoft 2010 and I do not see the "Microsoft Date and Time Picker"

Your profile says Excel 2003, I suggest you amend it.


Excel 2010 does not support Calnedar controls