3

I am a newbie to excel programing, I now have a problem with my excel add-ins code. My add-ins call out a Mainform. Whenever I call my method from this form's button to do some tasks, such as searching huge data, the Mainform is frozen, it's inevitable. But when the method is running, assume it then will call a childform, this child form is also pending, I cannot do anything with it.

My purpose is to call a child form to add in a progress bar and an Abort button to cancel the running method.

How can I solve this?

Thanks in advance for your help. vuhi

Improve this question

1 Answer 1

Reset to default
0

I believe you need to multi-thread to allow that; multi-threading using just VBA cannot be done.

See the answer to this question for more details.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.