Hi,
I have a user form that enters data into a workbook. With all the calc,vlookup, etc in the sheets, there is a delay when I send the data from the user form to the worksheets.
I would like to turn off the auto calc function in my workbook and then only calc when I close the user form. How can I do this using vba?
I have a user form that enters data into a workbook. With all the calc,vlookup, etc in the sheets, there is a delay when I send the data from the user form to the worksheets.
I would like to turn off the auto calc function in my workbook and then only calc when I close the user form. How can I do this using vba?