combo box

  • Thread starter Thread starter Lord Of The Morning
  • Start date Start date
L

Lord Of The Morning

Ok Another question, I created a combo box that has a list of states, can
whatever state is selected be transfered to another cell on a different
sheet?

Nick
 
if it is an activeX combobox from the control toolbox toolbar, in the
properties window (right click on the control while in design mode), select
linkedcell and put in an entry like

Sheet4!B9
 
If it was a combo box from the Forms toolbar, right-click it and set
the Cell Link to whatever cell in whatever sheet you want, say
Sheet2, A1. Selecting an item will return an index to the input
range, so your can then retrieve your value with

A2: =INDEX(rng, A1)
 
Lord,

If you have one cell, or several cells, as perhaps in a column, into which
you want to choose states from your list, you can use Data Validation. The
Combo box will open whenever one of the cell(s) is selected. Since your list
of states is in a separate sheet, you'll need to define a name for it
(because Data Validation doesn't allow direct references to other sheets for
the list. (Insert, Name, Define, or use the Name box -- at the left of the
formula bar). Select the cell(s) to get the dropdown (combo box) ), Data -
Validation - Allow: List, then in the List box, press F3, and choose the
defined name.
 
Instead of putting my state from my list into the linked cell it places a
1,2,3... and so on depending on where it falls in the list any idea why?
 
Lord Of The Morning said:
Ok Another question, I created a combo box that has a list of states, can
whatever state is selected be transfered to another cell on a different
sheet?
Click to expand...

Speaking of activeX combo boxes, I have noticed that their default
resizing begaviour is different from that for more mundane combo boxes.
How do you force the resize behaviour to be like the ordinary bombo
boxes?
 
Back
Top