Need to cast OleObject to ComboBox

L

Liline

Hello,
I would need to cast an OleObject into a Combobox because VBA Excel doesn't
seem to do it implicitely
That is for using the AddItem method on it (this method is not supported by
the OleObject)

This is my code
' OleObject(1) is supposed to be a combobox
ActiveSheet.OleObjects(1).AddItem "Hello"

Can someone help me please ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need to cast OleObject to CombBbox 1
Looping through checkboxes 5
How to read the contents of an OLEObject (dropdown list) in excel 0
Type Mismatch error when trying to generically set ComboBox to aComboBox variable 8
Linking a listtemplate to Heading 2 in combination with a combobox 0
OLEObjects - Paste combobox contents to a sheet 4
VSTO C# add in Outlook.Appointment error 0
Menu Macro Not Executing - Need Help 1

Top