Calculated fileds

[piotrpoletek]

Hi Cristian,

thanks for your email In attached form, issue is probably with calculated fields. When I turn on form with any data in calculated fields, scrolling is disabled. With empty calculated fields it works. I can't figure it out.

Thanks Form.zip .

[cristianbuse]

Hi Piotr,

The Zip file is empty.

[piotrpoletek]

Form.zip

[cristianbuse]

Hi @piotrpoletek ,

I cannot replicate the issue.

What do you mean by:

When I turn on form with any data in calculated fields, scrolling is disabled.

? How could I replicate that step by step?

[piotrpoletek]

Hi,

please put "1" into "total current assets 2022". Close the form. Open the form again and check scrolling.

[cristianbuse]

@piotrpoletek

I already did that and the scrolling works even after closing and re-opening.

Maybe try adding this to the form:

Private Sub UserForm_Terminate()
    DisableMouseScroll Me
End Sub

to force the unhook. But this is generally not needed.