Have a Run Time error??

[bralew]

Hi All,

When I clear the information from my Userform I get a "Run Time Code" error. I don't have any problems initially, only when I clear my userform
and re-input data. Its been working fine until now?

I have this in the module:

Please Login or Register  to view this content.

and this in the UserForm:

Please Login or Register  to view this content.

Any Thoughts?

[cytop]

Some indication of where the error occurs and the error number would help.

At a guess it'd be setting the combobox text - but I could be wrong...

[kasan]

Toggle breakpoint at the beginning of Clear sub and then test it step-by-step

[bralew]

Got this, which I picked up from breakpoint Toggle Too. It's a RunTime error 13

[kasan]

You are trying to multiply string with number?

[bralew]

Yes, the TextBox47.Value represents a Quantity, which changes so I can't put a numerical value in the code?

[xlnitwit]

As before, use

Please Login or Register  to view this content.

You might also consider using a variable to prevent events from running when you are performing actions like clearing the form.

[bralew]

Should i put:

Please Login or Register  to view this content.

instead of:

Please Login or Register  to view this content.

[bralew]

Should i put:

Please Login or Register  to view this content.

instead of:

Please Login or Register  to view this content.

[bralew]

You beat me to it!!!! i was a bit delayed but it dawned on me the problem!! Thanks All

[kasan]

Yes, in case you want to use value of this textbox as number

[xlnitwit]

No, you do not (and can not) use Val on the left side of the assignment.

[bralew]

I've de-bugged the whole lot. Lots of areas where I'd failed to put Val in front of TextBox. Works great now. I can clear my form and re-input data fine

[bralew]

Thanks everyone