Page 1 of 1

Insert listbox in excel sheet

Posted: Wed Oct 22, 2008 3:35 pm
by FerCastro
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

Posted: Wed Oct 22, 2008 4:46 pm
by FerCastro
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

Posted: Sun Oct 26, 2008 3:11 pm
by FerCastro
Anybody here has created a excel sheet with comboboxes inserted? I have faced some troubles with this feature of the comonent.

best regards

Fernando

Posted: Wed Oct 29, 2008 5:04 pm
by larsa
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.

Posted: Wed Oct 29, 2008 10:58 pm
by FerCastro
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

Posted: Sat Nov 01, 2008 10:45 pm
by FerCastro
No?

Ok, thanks a lot for your time.

FCG