How to add ComboBoxes properly?

[Guest]

Hello!

I try to add ComboBox, here is my code:

Code: Select all

uses ControlObj2;

 with XLS.Sheets[0].ControlsObjects.ComboBoxes.Add do begin
   SourceArea := 'A6:A9';
   DestCell := 'B2';
 end;

When I am running the .exe-file I get an error: 'Unknown SBS formula'.
What's wrong?
Could you post a code sample?

[larsa]

Hello

References must be absolute, and contain sheet name. Example: Sheet1!$A$1


Lars Arvidsson

[FerCastro]

Hello Larsa

I am deeply sorry if I sound unpolite, but I think your support is not as good as it should be. Some people here (me included) have been requesting some samples of code for the use of your compoent. I guess you are a very bussy person, i have no doubts about it, but my friend, if your goal is to sell the most components I think you could be closer to your potential customers.

Maybe our (or my) questios are really silly, but this is why i am asking: i dont know and i am not expert. I am evaluating your component because it seems to be the most complete in the market, to work with excel.

I just want to know if I can insert one Combobox in the excel sheet usnig your component, and if so, i need to test the code. I have one demo release, and the help maybe is very high for me, i need only 7 o 8 lines of code.

Thanks a lot for your time, and best regards.

Fernando Castro
México, D.F.