Re: Combo box - need idiots guide!

that's really useful thing to use the combo box, but here I have the question
regarding it:

I am using Combo-Box and when I click on the button to choose the data it
appears to the linked cell as it should be everything works fine, but I need
to see the data in the linked cell but not hte count number.

For example, I have 10 different numbers in A1:a10 range and my linked cell
is C10, i want that when I click on the second one there must be a second
number in the linked cell and not the 2, Is it possible?

Hope you understand the task.

I would be really appreciate for your help.

Thank you in advance
Regards
Alex

"Debra Dalgleish" wrote:

> On the Control toolbox, click the Design mode button
> Select the combo box
> On the Control toolbox, click the Properties button
> In the Properties window, for ListFillRange, type the name, or cell
> references, of your input range.
> Click the Exit Design Mode button.
>
> abfabrob wrote:
> > Thank you for this.
> >
> > However... when I click on format control, there is no where to input the
> > cell range.
> >
> > My options are: "size", "protection", "properties" and "web".
> >
> > Rob
> >
> > "Anthony Slater" wrote:
> >
> >
> >>Ok, lets make it simpler
> >>
> >>1. Fill *** 1 A1:A5 with some data such as Apple, banana, pear, orange,
> >>lemon
> >>2. Draw combo box somewhere on *** 1
> >>3. right click on combox
> >>4. format control
> >>5. Input range will be A1:A5
> >>6. Cell link will A10
> >>
> >>Thats it.
> >>
> >>When you click on the drop down, the list will show. Click on an item in the
> >>list will change the value accordingly in cel A10
> >>
> >>You can then use the value in cell A10 in another formula depending on what
> >>you really need from the out come. Such as IF(a10=1,"APPLE","ANOTHER KIND OF
> >>FRUIT")
> >>
> >>Don't forget to check contextures.com for more help
> >>
> >>"abfabrob" wrote:
> >>
> >>
> >>>I'm sorry, I really don't understand. Can you explain in more detail? I'm
> >>>really new to this. I don't know what you mean by naming the list (where/how
> >>>do I name it?). When I right click on the Combo box and go to format control,
> >>>I don't know where to input anything. And do I OLNY input "=mylist"? And
> >>>where do I input the fact that I want it to be in cell C10? (or whichever I
> >>>decide to use).
> >>>
> >>>Hope you can help!
> >>>
> >>>"Anthony Slater" wrote:
> >>>
> >>>
> >>>>Assuming you want a combo box in *** 1:
> >>>>
> >>>>Make a list in ***, lets say A1:A5. Name this list "mylist'
> >>>>
> >>>>Draw your combo box in *** one.
> >>>>Right click on it and choose format control. the input range would be =mylist
> >>>>the cell link will be anywhere you want (such as C10)
> >>>>
> >>>>Depending on what you choose from the drop down, C10 will change accordingly.
> >>>>
> >>>>HTH
> >>>>
> >>>>For more help, check out contextures.com
> >>>>
> >>>>"abfabrob" wrote:
> >>>>
> >>>>
> >>>>>I want to use a combo box as a drop down list. I know where to find the combo
> >>>>>box (in the control toolbox), but I have no idea how to populate it or
> >>>>>activate it...
> >>>>>
> >>>>>Any help will be appriciated for this real novice
> >>>>>
> >>>>>Rob.
> >>>>
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>


.