I am creating a form which will have quite a few components, frames, option buttons, Command boxees etc. When I have done similar things in VB it was easy to
print an inventory of the module with all the relevant details of the components. e.g. for option buttons you could see the names, height, width, top, font
etc. Can this be done with excel VBa.
I haven't a clue how to start but I assume it would have to be a macro. If this is the case could someone give me a starter outline please. I don't mind if
the info is on a created excel sheet or on to a new print file. Ideally for every component in my user form I would like to print say the height, width and top
for starters. If someone could start me on that I think I should be able to work out the rest for other properties

Thanks

DavidP