How to get text from dropdown list macro?

[EdByrnee]

This

Please Login or Register  to view this content.

Returns

"Object doesn't support this property"

How can I get the text in the combo box and not the number of the position in the list??? Been trying for about an hour and starting to lose sanity.

Thanks guys,
Ed

[Winon]

Hello EdByrnee,

Refer to each Combobox seperately, i.e.

Please Login or Register  to view this content.

, etc.

If you could upload a sample WorkBook with all your relavent Code, we could have a look at it more closely.