2 Coding scripts running at the same time...possible?

hey yer barred

Board Regular
Joined
Jun 19, 2007
Messages
232
Hi All

Is it possible for me to click a button that will run a report and still use other functions on a VB6 form at the same time?....even if it does has a effect on running speed
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
Hi

To be able to retain some sort of control over the interface after clicking a button, add some 'DoEvents' lines to your code - especially inside any loops that are running. It will slow performance but won't lock your VB6 interface.

HTH, Andrew

P.S. When I originally read this question, I thought you were wanting to take advantage of a multi-threading processor using VB6. If ever you do want to, then this looks like it is worth reading:
http://www.freevbcode.com/ShowCode.Asp?ID=1287
I realise it isn't directly related to what you want but thought I would post the link so that it is easier to find in future, given I want to experiment with this, and I am not at my usual PC! :)
 
Upvote 0

Forum statistics

Threads
1,225,364
Messages
6,184,534
Members
453,239
Latest member
dbenthu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top