Userform upload data very very slowly to sheets vba

Hi all,
I have made a great progress in excel with the help of this forum & members.
Currently I have done userform which works fine.
I have one issues:

Uploading data to sheets is extremely slow ( takes about 30 secs)
I suppose finding last row takes much of it.
Any suggestions to replace 'lastrow' concept?

OR any other solution please.


Please help
Thanks
Kind regards

Please Login or Register  to view this content.

I think this one it gives you the similar time....

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Hi,

Have you tried turning on/off the calculation?

Gaetan

Originally Posted by KK1234

Hi Aaron092,
I too tried this but it is not making much difference.
I think it may be due to the fact it is too long to find last row?
Any suggestions Please

K regs

No, that doesn't take any time at all.

First thing I would say is to set up links from DD to D so you don't have to output the same item in the form twice.

Second thing, fill in the ControlSource property for each of the controls. This is a string that is the address of the linked cell.

Third, add an event handler for the Change event on all of the controls and have them write the control Value property to its own ControlSource.
This way the cells will be updated as you type.

The third one is optional, but it gives a good feel to the user because the form will update as they type. So will the linked cells.
If you have an exit button then probably you won't need this to ensure that the linked cells are updated, but I'm not 100% sure about that.
It can be done the long way: manually type in an event handler for each control. (Which I don't recommend).
Or like this:

In a Class Module called cControl...

Please Login or Register  to view this content.

In the Form Module...

Please Login or Register  to view this content.