linking a form combo box... results from the combo box to another

[Guest]

i have a combo box which i have already linked it up to a range of cell's on
another sheet... this is a combo box with state's... how do i insert a
function/ formula so when a state is chosen the result's automatically
populate another cell...

trey

 

[Guest]

There are 2 types of combo boxes. Forms Control and ActiveX Control.
In xl2007 both appear from the Insert icon under Developer tab. In Earlier
versions the Form control one is accessed from the Forms Tool Bar and the
ActiveX one is accessed from the Control Tool Box Tool Bar.

I suggest that you use the ActiveX control combo Box. After creating the
combo box, ensure Design Mode is on. Usueally defaults to on as soon as you
create the combo box. If not, click on the Blue Set Square with pencil and
ruler icon and then right click on the the combo box and select properties.
Set the Linked cell to the cell where you want the results to display. For
example
Sheet2!D1. Set the List Fill Range to the range of required data. Don't
forget to turn off Design Mode when you have done this. If you need to
re-edit then you need to turn on design mode again.

If you use the Forms Control, You need to set a linked cell which will only
display a number representing the position of the data. You would then need
to put numbers in a separate column beside the input range and use VLOOKUP
function in your required cell and use the value of the linked cell to lookup
the data. Messy compared to ActiveX control.

Regards,

OssieMac