Page 1 of 1
How to add ComboBoxes properly?
Posted: Sat Apr 07, 2007 6:47 am
by 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?
Posted: Wed Apr 11, 2007 5:16 am
by larsa
Hello
References must be absolute, and contain sheet name. Example: Sheet1!$A$1
Lars Arvidsson
Posted: Sun Nov 02, 2008 2:08 am
by 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.