User Form not loading

[Mattyads2011]

Hi Guys.

I have assigned a macro to a drawing so that a userform I have created appears.

It used to work fine but I have since added some more labels and text boxes to the form and now it wont appear when i click on the drawing.

I have tried rewriting the macro but to no avail.

This is the first time I have used a form so I may have missed somethign really simple. This is what the coding looks like

Sub AutoShape92_Click()
TalentForm.Show
End Sub

Can any point out what I am doing wrong please?

 

[Andrew Poulsom]

Are you sure that you are clicking the shape to which the macro is assigned?

 

[Mattyads2011]

Hi Andrew.

Yes, when I click I get a runtime error 424 Object Required.

When I hit Debug it highlights the 2nd row of the code I used above.

 

[Andrew Poulsom]

Make sure that you have a UserForm named TalentForm in that workbook.

 

[Mattyads2011]

Ok done that, all good so far

 

[Andrew Poulsom]

Maybe there is an error in your UserForm module. See if checking 'Break in Class Module' under Tools|Options|General tab in the Visual Basic editor gets you a bit farther.

 

[Mattyads2011]

Ok might be getting somewhere now, I didnt mention before, because I had forgotten myself, that I have used an existing userform that a friend of mine had already designed and assigned some coding to (for some strange reason i seem to learn best by playing about with codes/formula that other people have done)

The Debug is now highlighting some of the coding which was meant to sort the data once the form had been filled in by a user.

If this is what is stopping it from loading I will have to revisit but surely this shouldnt stop the form from loading in the 1st place?

Thank you by the way Andrew, i appreciate your help with this.

 

[Andrew Poulsom]

Yes, an error in your UserForm code will prevent it from loading.