No sure what you're after, as a userform is not on a worksheet.

If you want the controls that are embedded on a worksheet, you could loop
through that WS's OLEObjects collection, testing for the type of control,
then it's caption, if applicable.

Dim Cntrl As Object

For Each Cntrl In Worksheets(1).OLEObjects
Debug.Print Cntrl.Name, Cntrl.progID
Next

As for userforms, I suppose you can get the info with
http://www.cpearson.com/excel/vbe.htm

NickHK

"Nigel RS" wrote in message
...
Anyone have code or know of a utility to list all userforms and controls
types and captions on a worksheet?

Thanks