Strange Behavior Excel 2007

[cstimart]

When I am creating UserForm1, the properties window data is present...I add a Label, ListBox and Command button and close the form.

If I click on Module1 in the Project Window, the properties window reflects the data, however, if I select UserForm1 in the Project Window, the properties do not appear. I can open the form, add code, etc...but when I run my Macro in Module1, I get an error that tells me there's no form?

I closed and re-opened Excel with the same results.

Is there a setting or something that's messin' this up?

 

[GlennUK]

And how about showing us all the macro listing?

 

[Ruddles]

If I click on Module1 in the Project Window, the properties window reflects the data, however, if I select UserForm1 in the Project Window, the properties do not appear.

The properties won't show if the userform isn't open in the design frame. You said you'd closed it. Double-click its name in the VBA Project Explorer window to re-open it and if the Properties window is visible, the userform's properties will appear in it.

Why your macro gives an error when showing your userform is another question though, and we'd need to see the code as Glenn says. Have you renamed your userform or is it still called UserForm1?

 

[cstimart]

I see the the properties do appear/disappear, unlike a module.

After further review, there was a portion of code that I had re-used that did reference another form that was not present.

Thanks!