Speedup Userform in VBA

I have a userform that takes 5+ seconds to save a row. I have tried everything in this http://analystcave.com/excel-improve-vba-performance/ page without success.

I am thinking that the OFFSET function is slow when writing to the spreadsheet.

Please Login or Register  to view this content.

Is there any way to speed up this code? Perhaps without using the OFFSET function?

I have seen some code that uses cells().

Please Login or Register  to view this content.

Thanks in advance

If it takes 5 seconds to write three values to your sheet, then you have something else going on.
Can you supply your workbook?

Thank you for your reply. Unfortunately I can't share the workbook.

Is the OFFSET function slow?

Originally Posted by waimea

Is the OFFSET function slow?

Nope.
Do you have lots of formulae?
or event code on that sheet?

I had put the part where i turn off screenupdating etc in the wrong part. Now it takes 1 second.

Thank you for your reply!

Unfortunately I can't share the workbook.

why not?

Please Login or Register  to view this content.

Originally Posted by waimea

Thank you for your reply!

You're welcome

Hi

sub: Filtering combobox and resulting listbox

I want a userform to filter following items from the list. please help me. this is my first thread so please help.
all the comboboxes (Dynamic) should be related to each other. and results as filtered data should reflect in listbox.

Fields
KFI Operator
Verify Operator
KFI Error
Verify Error

and the table is as below:

I have 16 columns:

Fields is in column 5
KFI Opt is in 9
Verify Opt is in 10
KFI Error is in 13
Verify Error is in 14.


Thanks,
Umesh