Multiple columns in combo box problem

[jasondodd]

Hi all,

Quick question on something I've found I can't do. In M$ excel, I frequently use a combo box displaying the contents of column1 while reporting the contents of column2 into a linked cell. (in excel, this is the bound column of a 2-column count)

I can't find a way to show the info from one column in a table in the combo box while reporting the corresponding value from column 2 into the linked cell. Is this possible? Thanks

Example table

Retail 5%
Early 7%
Late 10%
(be able to pick Retail, Early, or Late from the combo box, while reporting 5,7, or 10% to the linked cell.

Jason

[RickRandom]

Can you describe how you do this in Excel? Then someone here can probably "translate" your method into Calc.

In either program, I'd probably use VLOOKUP().

[jasondodd]

sure,

In excel, you create the combo box, then go to it's properties. There you similarly list the list range source, and the linked cell, but in excel's properties, you have the abilility to say number of columns, bound column(the one to report to the linked cell), and column widths(can specify with widths to only show one). The main difference is that in excel this is using a VB control and not a form control I believe.

Thanks!

[Villeroy]

List/Combo-boxes cant have multiple columns but this may help you to fake one: http://www.oooforum.org/forum/viewtopic.phtml?t=30863&highlight=listbox
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org