Oops - sorry, forgot to add the most important property.

set the RowSource property of the combobox to Sheet1!Data

Assuming of course that the table is on Sheet1


Rgds

On Fri, 05 May 2006 14:11:01 +0100, Richard Buttrey
wrote:

On Fri, 5 May 2006 07:03:33 -0500, MWP
wrote:


I am trying to creat a calculator of U values (heat loss) and would like
to use a pull down menu (like in a combo box) for thicknesses of a
composite material to give differing values in another cell. For
example, if I pull down to 20 I would like 0.34 to appear in another
cell and if I pulled down to 30 I would like 0.37 to appear etc. Does
anyone have any ideas or know where I might look? I am a complete
novice on this side of excel so any help much appreciated!

One way

Build a table of values. e.g.

A1=20, B1=.34
A2=30, B2=.37

etc., and name this range say "data"

Now with your combobox set the following properties.

ControlSource: Sheet1!D1
BoundColumn: 2
ColumnCount: 1

When you invoke the combobox you should now see the values in A1:A2 in
the drop down list. Choosing one and dismissing the control will put
the appropriate value from B1:B2 in cell D1.

HTH

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________