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