Error report

[WJReid]

Hi All,

I am working on a client's workbook which has forms on it. Information can be added through the textboxes for a while, then I get a message 'exception occurred'. Can anyone help me please. When the message comes up you have to close the form and any data that was entered in the form is lost. I am using XP Pro and Office 2000.

Thanks in advance for any assistance.

Regards,

Bill

 

[davers5]

I think we'll need to see some code for the form. Go to the visual basic editor, Tools-Macro-Visual Basic Editor. In the top left corner, there is a project window. Find the workbook you're working with. Find the forms folder and expand it, there should be a userform under there. Double click on it and it should pop up on the screen. Then go to view-code and the code module should pop up. Copy it all and paste it into a posting. Then maybe we'll be able to tell what's going on.

Dave S.