Hi,

I am trying to create a template for user to identify what categories
does the product fit into.
I believe that Combo Box is the way to do it, but i cant get it to
display on the right cell...

eg. ColA Col B
Row1 product category(combo)
Row2 apple
Row3 Car
Row4 Cat
Row5 Books

I used a combox in B1 where user can choose between Fruits, Animals and
Miscellaneous, but it only display 1,2,3 on B2 and wont move to the
next row.

Is there a way to show the category value in the approprite box?
ie. select B3, click on the combo box, select the category and then the
value will be displayed on B3?

and same as B4, B5, B6....etc??

Thanks.
Elaine.

It sounds like you used a DropDown from the Forms toolbar.

You could use another cell based on the linked cell:

Say B1 is the linked cell (hide that column???) and put a formula like:

=if(b1="","",index(A2:a99,b1))

========
But even easier is to use Data|Validation. It looks like a dropdown and the
value goes directly into that cell.

You can find lots of tips for Data|Validation at Debra Dalgleish's site:
http://www.contextures.com/xlDataVal01.html

wrote:

Hi,

I am trying to create a template for user to identify what categories
does the product fit into.
I believe that Combo Box is the way to do it, but i cant get it to
display on the right cell...

eg. ColA Col B
Row1 product category(combo)
Row2 apple
Row3 Car
Row4 Cat
Row5 Books

I used a combox in B1 where user can choose between Fruits, Animals and
Miscellaneous, but it only display 1,2,3 on B2 and wont move to the
next row.

Is there a way to show the category value in the approprite box?
ie. select B3, click on the combo box, select the category and then the
value will be displayed on B3?

and same as B4, B5, B6....etc??

Thanks.
Elaine.

--

Dave Peterson

Hi,

Yes, I use the drop down from the Forms toolbar, and My input range is
F1:F3.
Cell link is $B:$B. Using this formulat
=IF(B1="","",INDEX($F$1:$F$4,B1))

the category I select should be displayed in Col C. However, it only
displays on the first row, but not the rest...

eg. ColA Col B(hide) ColC Col F
(catergory)
Row1 product fruit
Row2 apple animal
Row3 Car mis
Row4 Cat
Row5 Books

What I would like to do is when I select C4, I go to the drop down list
and select animal, and "animal" will be displayed in C4.

when I select C2, I go to the drop down list and select fruit, and
"fruit" will be displayed in C2.

Am I on the right track?

Thanks.
Elaine.





But it only display on the first line, ie, when i click on
Dave Peterson wrote:
It sounds like you used a DropDown from the Forms toolbar.

You could use another cell based on the linked cell:

Say B1 is the linked cell (hide that column???) and put a formula like:

=if(b1="","",index(A2:a99,b1))

========
But even easier is to use Data|Validation. It looks like a dropdown and the
value goes directly into that cell.

You can find lots of tips for Data|Validation at Debra Dalgleish's site:
http://www.contextures.com/xlDataVal01.html

wrote:

Hi,

I am trying to create a template for user to identify what categories
does the product fit into.
I believe that Combo Box is the way to do it, but i cant get it to
display on the right cell...

eg. ColA Col B
Row1 product category(combo)
Row2 apple
Row3 Car
Row4 Cat
Row5 Books

I used a combox in B1 where user can choose between Fruits, Animals and
Miscellaneous, but it only display 1,2,3 on B2 and wont move to the
next row.

Is there a way to show the category value in the approprite box?
ie. select B3, click on the combo box, select the category and then the
value will be displayed on B3?

and same as B4, B5, B6....etc??

Thanks.
Elaine.

--

Dave Peterson

I would think that Data|Validation would be easier to implement.

(I don't understand what you mean by the cell link is column B, though. I would
think you'd want a single cell per dropdown (if you choose to keep those
dropdowns).)

wrote:

Hi,

Yes, I use the drop down from the Forms toolbar, and My input range is
F1:F3.
Cell link is $B:$B. Using this formulat
=IF(B1="","",INDEX($F$1:$F$4,B1))

the category I select should be displayed in Col C. However, it only
displays on the first row, but not the rest...

eg. ColA Col B(hide) ColC Col F
(catergory)
Row1 product fruit
Row2 apple animal
Row3 Car mis
Row4 Cat
Row5 Books

What I would like to do is when I select C4, I go to the drop down list
and select animal, and "animal" will be displayed in C4.

when I select C2, I go to the drop down list and select fruit, and
"fruit" will be displayed in C2.

Am I on the right track?

Thanks.
Elaine.

But it only display on the first line, ie, when i click on
Dave Peterson wrote:
It sounds like you used a DropDown from the Forms toolbar.

You could use another cell based on the linked cell:

Say B1 is the linked cell (hide that column???) and put a formula like:

=if(b1="","",index(A2:a99,b1))

========
But even easier is to use Data|Validation. It looks like a dropdown and the
value goes directly into that cell.

You can find lots of tips for Data|Validation at Debra Dalgleish's site:
http://www.contextures.com/xlDataVal01.html

wrote:

Hi,

I am trying to create a template for user to identify what categories
does the product fit into.
I believe that Combo Box is the way to do it, but i cant get it to
display on the right cell...

eg. ColA Col B
Row1 product category(combo)
Row2 apple
Row3 Car
Row4 Cat
Row5 Books

I used a combox in B1 where user can choose between Fruits, Animals and
Miscellaneous, but it only display 1,2,3 on B2 and wont move to the
next row.

Is there a way to show the category value in the approprite box?
ie. select B3, click on the combo box, select the category and then the
value will be displayed on B3?

and same as B4, B5, B6....etc??

Thanks.
Elaine.

--

Dave Peterson

--

Dave Peterson

oh yes! I didnt see the link that you provided on the previous post.
Thats what I am looking for! Thank you very much!!!! Its very useful!!

elaine.


Dave Peterson wrote:
I would think that Data|Validation would be easier to implement.

(I don't understand what you mean by the cell link is column B, though. I would
think you'd want a single cell per dropdown (if you choose to keep those
dropdowns).)

wrote:

Hi,

Yes, I use the drop down from the Forms toolbar, and My input range is
F1:F3.
Cell link is $B:$B. Using this formulat
=IF(B1="","",INDEX($F$1:$F$4,B1))

the category I select should be displayed in Col C. However, it only
displays on the first row, but not the rest...

eg. ColA Col B(hide) ColC Col F
(catergory)
Row1 product fruit
Row2 apple animal
Row3 Car mis
Row4 Cat
Row5 Books

What I would like to do is when I select C4, I go to the drop down list
and select animal, and "animal" will be displayed in C4.

when I select C2, I go to the drop down list and select fruit, and
"fruit" will be displayed in C2.

Am I on the right track?

Thanks.
Elaine.

But it only display on the first line, ie, when i click on
Dave Peterson wrote:
It sounds like you used a DropDown from the Forms toolbar.

You could use another cell based on the linked cell:

Say B1 is the linked cell (hide that column???) and put a formula like:

=if(b1="","",index(A2:a99,b1))

========
But even easier is to use Data|Validation. It looks like a dropdown and the
value goes directly into that cell.

You can find lots of tips for Data|Validation at Debra Dalgleish's site:
http://www.contextures.com/xlDataVal01.html

wrote:

Hi,

I am trying to create a template for user to identify what categories
does the product fit into.
I believe that Combo Box is the way to do it, but i cant get it to
display on the right cell...

eg. ColA Col B
Row1 product category(combo)
Row2 apple
Row3 Car
Row4 Cat
Row5 Books

I used a combox in B1 where user can choose between Fruits, Animals and
Miscellaneous, but it only display 1,2,3 on B2 and wont move to the
next row.

Is there a way to show the category value in the approprite box?
ie. select B3, click on the combo box, select the category and then the
value will be displayed on B3?

and same as B4, B5, B6....etc??

Thanks.
Elaine.

--

Dave Peterson

--

Dave Peterson