Vba Userform taking too long to insert value to worksheet from text box

**sthiru** · 05-15-2015, 01:58 PM

Hi

I have created a Add button in userform and I coded but when it runs it taking too long time to insert the values to worksheet from userform textbox i'm not sure why...

Can you guys please help.

Thanks
Thiru

**skywriter** · 05-15-2015, 10:10 PM

It's a very large form with many tabs and many boxes. We need to know which tab you are using and what data to put in what boxes when the problem occurs. What button to push etc.

We need to recreate exactly what you are doing when this happens.

Thanks.

**sthiru** · 05-15-2015, 11:34 PM

Originally Posted by skywriter

It's a very large form with many tabs and many boxes. We need to know which tab you are using and what data to put in what boxes when the problem occurs. What button to push etc.

We need to recreate exactly what you are doing when this happens.

Thanks.

Thank you for your message!

**skywriter** · 05-16-2015, 01:12 AM

Okay that answers the tab part, what about the other questions? What do we enter into or do with each box and which button do we push?

**sthiru** · 05-16-2015, 04:44 AM

Originally Posted by skywriter

Okay that answers the tab part, what about the other questions? What do we enter into or do with each box and which button do we push?

Just a normal values, you can enter any values 1,2,a,b,c anything but whatever we enter it takes almost 30 to 40 seconds for 6 text boxes.

Thanks
Thiru

**6StringJazzer** · 05-16-2015, 11:55 AM

Thiru, you need to read all the questions and answer all the questions.

What fields are required to be filled in, and what button do we push? In your first post you said "Add" button but there is no "Add" button.

**sthiru** · 05-16-2015, 02:26 PM

Deleted DeletedDeletedDeletedDeletedDeletedDeletedDeletedDeletedDeletedDeletedDeletedDeletedDeletedDeletedDeletedDeletedDeletedDeletedDeletedDeletedDeletedDeletedDeletedDeletedDeletedDeletedDeletedDeletedDeletedDeletedDeletedDeletedDeleted

**6StringJazzer** · 05-17-2015, 08:34 AM

That's better

It seems to me that it should not be that slow, but I have implemented a change that speeds it up.

Your are doing over 100 write operations to individual cells. This can be done in a single operation with an array. I have declared an array called Arr and stored all the data in the array. This is much faster than writing data to cells. Then I dump the array to the worksheet all at one time, also much faster than individual writes.

You will need to check your output to make sure it is still correct.