ComboBox lag

[kandoo1]

Capture.jpg
I am having a weird lagging problem with my comboBoxes. There is a folder in ComboBox2("company") that is about 15GB and when I select that, It takes about 10 seconds to load. I noticed that If the folder is populated to the other two comboboxes, it doesn't lag there for some reason. It is ****ing me off and I can't find a way around it

Is there a way to get rid of my lagging problem on comboBox2?

Please Login or Register  to view this content.

[Keebellah]

Hi, welcome,
Are the S: and M: network shares or external (SUB) harddrives?
It's a typical Windows issue when browsing, it takes a moment to 'wake-up'.
If I address my NAS the first time it lags too but then it's okay and I have USB drive that always has to be 'woken-up' cannot keep it alive, I understand the issue but have no solution for it.

[kandoo1]

Hi, welcome,
Are the S: and M: network shares or external (SUB) harddrives?
It's a typical Windows issue when browsing, it takes a moment to 'wake-up'.
If I address my NAS the first time it lags too but then it's okay and I have USB drive that always has to be 'woken-up' cannot keep it alive, I understand the issue but have no solution for it.

Thank you.

Those are both shared drives. The problem is that in the S drive, everything works perfectly but when it comes to the M drive, that one folder lags. I am not sure if it is the size or the code that I have there. Everything else works fine in the M drive.

[Keebellah]

If you right click on the folder en select properties you will know how many files are in that folder and how large that folder is.
You could disable your AntiVirus for a moment to test if that makes a difference, maybe the file types in that folder trigger an extra action that gives the lag.
Don't forget to activate AV again.

[bakerman2]

How about this ?
code in module2.

[kandoo1]

How about this ?
code in module2.

@bakerman2

Thanks for the code. It seems to run fast but there is a problem. When I run the code, the first thing that pops up instead of the userform is " Msgbox " Wrong year?". When I click on OK, then try to choose something from the second comboBox, I get another popup " typo or company found" etc etc.

So i keep getting popups.

Thanks

[Keebellah]

That means an error has occurred.

Please Login or Register  to view this content.

Have you tried stepping though the code (line-by-line)? Open VBA editor select the macro and press F8

[kandoo1]

That means an error has occurred.

Please Login or Register  to view this content.

Have you tried stepping though the code (line-by-line)? Open VBA editor select the macro and press F8

yeah, the weird thing is that it keeps working as i am getting the errors. His code is pretty advanced, I don't understand it. lol

[Keebellah]

I cannot test it becasue I do not have a file with the userform
But even if the code is 'pretty advanced' you can floow it step by step and check the moent if goes to the error line.

You can disable the On error goto by placing a ' in front of that line, that way you get the actual error when it happens and then debug to check what the reason is for this error.

[bakerman2]

This way it works for me without any MsgBox.
Trouble posting code so have to put it in file.

[kandoo1]

This way it works for me without any MsgBox.
Trouble posting code so have to put it in file.

This one works, but Now I can't have error Traps. lol

also, is it possible to get rid of the CMD flashing everytime I select something from the ComboBoxes?

Thanks

[Keebellah]

No file, no idea what is flashing...

[kandoo1]

No file, no idea what is flashing...

I can't attach files yet because of I am new to the forum, but I have hosted it here if you like to download it

http://expirebox.com/download/8968a0...4634a839c.html

you will have to change the code with Bkerman2's code .

[Norie]

Please don't cross post.

[Keebellah]

The expirebox link is blocked and marked ads untrustworthy by my protection software.
Please seek another way.

[kandoo1]

Are you still around? I am still having that issue.

Someone please help me solve this problem.

[Keebellah]

Here is the information to attach a file

Please keep in mind that we do not have the same conditions you have with a S and an M shared drive.

[kandoo1]

Have a look please.

M drive(Jobs2017) is 17.2 GB.

to launch the macro, CTRL + SHIFT + D

[Keebellah]

The attached zip file seems to be corrupt, cannot open it, it asks for a disk.
Could you please check and reattach?

[kandoo1]

This one better work. :/

[Keebellah]

The file is okay but like I mentioned, not much I can do for you.
The code is full of hard-code filepaths that do not exist on my system so I get 'Wrong Year' due to the error trapping and the the rest goes wrong because of the file paths.
So, I'm sorry, hope someone else can help.
BTW why an xls file? Is this Excel 2003 or earlier?
It's past midnight here, so I'm off to bed now.