I can't get my macro to run!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

NickNick - 23 Jan 2006 20:58 GMT

I'm sure the answer to this is straightforward, but I can't find out
where I'm going wrong! I've done a bit of VB in Excel but it's all been
very simple.

I've followed the "Create User Form Turtorial" from this site and
adapted it as I needed to. I'm assigning the macro to a button and need
to create a new module (according to the tutorial) and this is what I've
entered for the module.

Sub OpenCommentsandDiscipline()
frmComments.Show
End Sub

frmComments is the name of the User Form I've created. When I try and
run the macro I get a "Run-time error 424 Object Required" The
debugger goes straight to frmComments.Show and highlights it.

I can't see what the problem is... :(

Signature

NickNick

Reply to this Message

Norman Jones - 23 Jan 2006 21:11 GMT

Hi NickNick,

Check that the userform is named frmComments.

If the workbook did not contain a userform named frmComments, you would
receive the encountered error.

---
Regards,
Norman

> I'm sure the answer to this is straightforward, but I can't find out
> where I'm going wrong! I've done a bit of VB in Excel but it's all been
[quoted text clipped - 14 lines]
>
> I can't see what the problem is... :(

Reply to this Message

NickNick - 23 Jan 2006 22:19 GMT

The user form is called frmComments

Signature

NickNick

Reply to this Message

avveerkar - 24 Jan 2006 05:55 GMT

Just check using object browser in VB code that the name is correct and
not UserForm1 or something. In my opinion userForm.name is a read-only
property and cannot be changed. More likely, the name is UserForm1 or
UserForm2 etc. I think frmComments could be the caption of the form and
not name. UserForm1.Show should work.

And if you have been able to change the name of the form to frmComments
from say UserForm1 please let me know how you did it.

A V Veerkar

Signature

avveerkar

Reply to this Message

Ed - 24 Jan 2006 17:22 GMT

avveerkar:

> And if you have been able to change the name of the form to frmComments
> from say UserForm1 please let me know how you did it.

Open the form. Press F4 to bring up Properties. Make sure you're viewing
the Properties for the form itself. One item is (Name) - it's usually at
the very top. Put your desired name there, and it should rename the form in
the Project Explorer.

NickNick:
Check to make sure the form is accessible in the project you're working
with. Did you create the form in a different workbook that's also open?
Have you declared and set an object to frmComments? Have you tried
UserForms("frmComments")? Have you tried to Load first and then Show?

HTH
Ed

> Just check using object browser in VB code that the name is correct and
> not UserForm1 or something. In my opinion userForm.name is a read-only
[quoted text clipped - 6 lines]
>
> A V Veerkar

Reply to this Message