Need to cast OleObject to ComboBox

  • Thread starter Thread starter Liline
  • Start date Start date
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 ?
 
Back
Top