IXlsFormComboBox
COM interface ( getting help with interfaces )

 

interface IXlsFormComboBox : IDispatch
{
  [id(1),propget] HRESULT AlternativeText([out, retval]BSTR* text);
  [id(1),propput] HRESULT AlternativeText([in]BSTR text);
  [id(2),propput] HRESULT VBAMacro([in]BSTR macro);
  [id(2),propget] HRESULT VBAMacro([out, retval]BSTR* macro);
  [id(3),propput] HRESULT LinkedCell([in]BSTR formula);
  [id(3),propget] HRESULT LinkedCell([out, retval]BSTR* formula);
  [id(4),propput] HRESULT InputRange([in]BSTR formula);
  [id(4),propget] HRESULT InputRange([out, retval]BSTR* formula);
  [id(5),propput] HRESULT DropLines([in]int droplines);
  [id(5),propget] HRESULT DropLines([out, retval]int* droplines);
  [id(6)]         HRESULT SelectItem([in]int index);
  [id(7),propget] HRESULT Name([out, retval]BSTR* name);
}

 

HRESULT AlternativeText([out, retval]BSTR* text);
returns the alternative text. Optional.

HRESULT AlternativeText([in]BSTR text);
sets the alternative text. Optional.

HRESULT VBAMacro([in]BSTR macro);
sets the vba macro name for the form combo box.

HRESULT VBAMacro([out, retval]BSTR* macro);
returns the vba macro name for the form combo box.

HRESULT LinkedCell([in]BSTR formula);
sets the linked cell for the form combo box. Usually of the form =RxCy

HRESULT LinkedCell([out, retval]BSTR* formula);
returns the linked cell for the form combo box. Usually of the form =RxCy

HRESULT InputRange([in]BSTR formula);
sets the input range for populating the form combo box. Usually of the form =R1C1R2C2

HRESULT InputRange([out, retval]BSTR* formula);
returns the input range for populatingthe form combo box. Usually of the form =R1C1R2C2

HRESULT DropLines([in]int droplines);
sets the number of drop down lines when the combo box is expanded. Default is : 8.

HRESULT DropLines([out, retval]int* droplines);
returns the number of drop down lines when the combo box is expanded. Default is : 8.

HRESULT SelectItem([in]int index);
sets the i-th item in the input range. Starts at 1.

HRESULT Name([out, retval]BSTR* name);
returns the name of the form combo box.