Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
linking a form combo box... results from the combo box to another
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
linking a form combo box... results from the combo box to another
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 "Trey" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using results of a combo box | Excel Discussion (Misc queries) | |||
Combo Box Linking | Excel Discussion (Misc queries) | |||
Results from a combo box into a formula | Excel Worksheet Functions | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
Form Combo Box | Excel Discussion (Misc queries) |