Insert listbox in excel sheet

FerCastro · Post by **FerCastro** » Wed Oct 22, 2008 3:35 pm

Hello,

I am trying to insert comoboxes in a excel sheet with this component. I found this component is capable to insert macros and visual components into a excel sheet created with XLSReadWrite. Is there a demo or src?

Thanks in advance

Fernando C
Mexico

FerCastro · Post by **FerCastro** » Wed Oct 22, 2008 4:46 pm

Hello,

I have found something in the help file.

This is what I do:

with XLS.Sheet[0].ControlsObjects.ComboBoxes.Add do begin
Left := 10;
Top := 10;
Width := 200;
Height := 40;

But in the excel sheet i get only the button of the listbox. I have tryed to set the control with some properties taken from the Macro made with the VB module in excel, but until now i get some errors.

Somebody can send me a clue about what i am doing wrong?

Best regards, and please forgive mistakes

Fernando C.
Mexico

FerCastro · Post by **FerCastro** » Sun Oct 26, 2008 3:11 pm

Anybody here has created a excel sheet with comboboxes inserted? I have faced some troubles with this feature of the comonent.

best regards

Fernando

Post by **larsa** » Wed Oct 29, 2008 5:04 pm

Hello

Create an excel file with a combo box, read the file with XLSReadWriteII and check what the various properties for the combo box are.

FerCastro · Post by **FerCastro** » Wed Oct 29, 2008 10:58 pm

Thanks,

You mean the hel file? because I have only DCU files, not pas files.

By the way, I have done all the steps in the help file but I can only get the button of the combobox, but not the combobox.

I have Office 2003 Prof, in spanish, and Delphi 2007

Best regards and thanks

FerCastro · Post by **FerCastro** » Sat Nov 01, 2008 10:45 pm

No?

Ok, thanks a lot for your time.

FCG