Userform Help - Field List?

[kidwispa]

I've recently inherited an Excel 2003 spreadsheet that includes a userform (from the person who was doing my job before me) and have been set the task of tidying it up and making it work properly. I'm currently in the process of trying to set the tab order but for some reason there are fields listed that don't seem to appear on the userform (I've been through all of the visible fields on the userform and jotted down the names so I know all required fields).

Is there any way to see a list of all created fields in order to delete these additional unneccessary fields that the author of the file created, or if this isn't possible is there a way to search for individual fields and manually delete them?


Thanks

Craig

 

[RoryA]

The combobox at the top of the Properties window should allow you to select controls from its list.

 

[kidwispa]

That's great, but how do I delete the fields I don't need once selected if they don't 'appear' on my userform? I've tried moving all the fields around to make sure there weren't fields on top of other fields and managed to find some that way, but there are still 20+ fields I can't see when selected from the drop down list at the top of the properties window.

 

[RoryA]

When you select one from the list it should be selected on the form, so if you click a blank (i.e. white) bit of the main code window (don't click the userform itself) you can just press delete. Or check the Top and Left properties to see if they are positioned offscreen.

 

[kidwispa]

Thanks - on closer inspection it turned out that I'd somehow copied frames into other frames so when I made them bigger these fields were visible... really need to get some training on this...