Excel 2007 : Getting a run-time 424 error when running a userform

[slumdog10]

Hi, I am new here and have just joined , I am working on a project in excell 2007 and have created a user form but when I run it it shows and then after I add date and click submit it brings back an error sayng

Please Login or Register  to view this content.

then when I click on the debug it highlights the first line of code.

Here is my code

Please Login or Register  to view this content.

This is the first time I have used this form and still learning,

Any help would be great thanks.

[royUK]

It's not recognising the sheet

Use

Please Login or Register  to view this content.

[slumdog10]

Hi I have tried the code you mentioned and it still now coming back with the error

Please Login or Register  to view this content.

I have uploaded my file I think. I am trying to use the form to allow me to add pupils details to the pupil db sheet,

new instructor workbook.xlsm

Please help

Thanks

[abousetta]

Hi,

Maybe try this:

Please Login or Register  to view this content.

[slumdog10]

Hia abousetta that worked perfectly your a star..

Is there anyway that the data in the boxes can disapear after clicking the submit button so I can keep adding data, currently it just stays there and I have to delete each text box area.

thanks again

[abousetta]

You can either add another button and add this code to it:

Please Login or Register  to view this content.

or you can just add it to the end of the routine above before the End Sub. If you are going to add more names before you close the form, may suggest something like adding:

Please Login or Register  to view this content.

before the line

Please Login or Register  to view this content.

This will clear the form each time you click the current button. Of course then you need to create a second button to close the userform (unload) when you are done adding all the information.

Good luck.

abousetta

[slumdog10]

That worked a treat using the controls code before the next bit.

Thanks that has had me stumped for days.

[abousetta]

Glad I could help. If you are satisfied with the responses the please mark the thread as solved.

Good luck.

[slumdog10]

Hi how do I mark this as solved.?

[abousetta]

The instructions are in the forum rules, and also in the FAQ

Thanks.