Unable to Execute Reset Userform...Runtime Error :-(

[aeolusquiniquini]

Hi,

I have created this userform with a database in excel and I am facing some coding problems.

I was able to have every attribute working with a percentage of score being displayed as you go along the each attribute in the form. I am able to save it, but when I try to do the command button "Reset", then it gives me an error. Run-time error "6' Overflow.

and it refers me to this string of commands Entry_Form.Score_Achieved.Value = Format(score/weight, "#%")

Can someone please help me out? Been trying to google some resolution myself and couldn't find one.

Attached is a sample of the sheet.

Thanks

[6StringJazzer]

I will look at your file but the first thing I would check is see if weight is 0 when this happens.

[aeolusquiniquini]

Thank you so much.

If I do Entry_Form.Scored_Achieved.Value = Cstr(score) & " /" & Cstr(weight), it works. I am able to execute the reset command. But i needed to show the percentage as the actual score, so when I changed the formula the one mentioned on the orginal post, the error occurs.

[6StringJazzer]

When you clear out your form, you are blanking out all the combo boxes. Each time you do this, you trigger the Change event, which calls Add_Scores. When weight is zero (because you blank it out, too), you get a divide-by-zero overflow.

You should not even be calling Add_Scores when you reset the form. You should have a global Boolean variable in your form, called something like Resetting. You set it to TRUE at the beginning of cmd_Reset_Click. Then in your combobox Change handlers, make the first line of code

Please Login or Register  to view this content.

Two other suggestions, from a user interface design standpoint. You have a lot of choices that are all Yes/No/NA. The user has to click twice on each one to select it, once to select it, and then to make a choice. And there are a lot of them. You can save the user a lot of time and frustration by using option buttons instead (one click each).

Second, rather than validating the input after the user clicks Save, keep the Save button disabled until the user has filled in all required data. The way it is now, if the user makes multiple mistakes, the code only tells him one at a time. I had to click Save several times to test your file.

[aeolusquiniquini]

Sorry about that, I am really new to this and that is why most of my codes are long ones. I am still learning what the new shortcuts for these are. I actually studied this lesson in youtube but it used the long method of coding. I am really not familiar how to form a formula for that Reset, I just did recycled some from my old forms. I did some googling for the scores and just learned how to add it out to my existing one.

[aeolusquiniquini]

The interface I can definitely modify that, it was just what my manager wanted to see. But I can definitely improve and propose it to her. I already got an idea on how to do that enable.disable Save button for the validation.

So I am now down to that Overflow error message still, will you be able to assist me in how to solve that problem? You may start the code and I can try to learn it and use it on the others.

Thank you in advance sir.

[6StringJazzer]

Attached is your file with the solution I suggested for Reset.