Excel form captions + list selection

[Lonelypixel]

Hi,
I'm trying to build some MS Office test automation functions at work in VC++. Accessing all the Excel form properties through this OLE thing (don't know what it's called exactly). Works fine so far.

But there's one thing I'm missing at all: How can I get the caption of an Excel-proprietary form control? Say a commandbutton or a checkbox.

I have the VBA name, location (in something like pixels * anything), whether the checkbox is checked (funny thing that, 'value' is always in {-4146, 1, 2}...) aso. But I need the control's caption to find it from the user's description. It doesn't even seem to be mentioned in the Excel/VBA help, and that's where I look first for a description of the otherwise undocumented C++ wrapper classes.

Ehm, no, I'm not talking about the ActiveX controls in Excel, I mean the other ones from the "Form" toolbar... (German version: "Formular")

Can anyone help me out with this? TIA -yves


edit: Today I found that there's also no possibility to read the selected items from a multi-select listbox. At least I didn't find anything in the documentation, again. Seems Excel controls were only intended for display purposes but not to control them by code