Overflow error when opening the Userform

[intex]

Hi,

I have a problem with the userform, it was working fine until i have deleted some data from the DataBase sheet and now when i click button to open the userform it says "Run-time error '6': Overflow".

I use this database at work and now it have crashed and i dont have a working copy.

Maybe somebody can help me with this issue below i have attached the sample file. Thanks in advance.

[Norie]

Label73's caption is '0', so you are dividing by zero here:

Please Login or Register  to view this content.

[intex]

Hi Norie is there any error handler can be created to avoid this error.

Thanks for your help

[Norie]

You could test for '0'.

Please Login or Register  to view this content.

[intex]

Brilliant as always Norie, thanks alot.