I am trying to use a combo box to select a text item from the list, once I
select this text item, I want it to place a $0 into another cell.

example: I select from combo box - Teriyaki Chicken, then I want $7.00 to
appear in cell C8 which will in turn be used to calculate a total based on
several other cells.

I just need to know how to take the text from the combo box in cell A8 and
place a dollar figure $7.00 in cell C8.

How about a slight alternative?

Instead of using a combobox, how about using Data|Validation.

You can set up another worksheet with the values to be chosen in the
data|validation dropdown in column A. Then put the associated price in column
B.

Say you put the data|validation cell in B8.

then in C8, you could use:

=if(b8="","",vlookup(b8,sheet2!a:b,2,false)

Debra Dalgleish has some nice notes about data|validation at:
http://www.contextures.com/xlDataVal01.html

And she has other nice notes about =vlookup() at:
http://www.contextures.com/xlFunctions02.html

John wrote:

I am trying to use a combo box to select a text item from the list, once I
select this text item, I want it to place a $0 into another cell.

example: I select from combo box - Teriyaki Chicken, then I want $7.00 to
appear in cell C8 which will in turn be used to calculate a total based on
several other cells.

I just need to know how to take the text from the combo box in cell A8 and
place a dollar figure $7.00 in cell C8.

--

Dave Peterson

Thanks, but have not used or heard of data validation. I will have to look
her up and delve a little deeper into my Excel Inside Out book. I think this
one I will need a little more help with. I will try what you suggested and
get back to you for anymore help I may need.

But can it be done with a combo box?


"Dave Peterson" wrote:

How about a slight alternative?

Instead of using a combobox, how about using Data|Validation.

You can set up another worksheet with the values to be chosen in the
data|validation dropdown in column A. Then put the associated price in column
B.

Say you put the data|validation cell in B8.

then in C8, you could use:

=if(b8="","",vlookup(b8,sheet2!a:b,2,false)

Debra Dalgleish has some nice notes about data|validation at:
http://www.contextures.com/xlDataVal01.html

And she has other nice notes about =vlookup() at:
http://www.contextures.com/xlFunctions02.html

John wrote:

I am trying to use a combo box to select a text item from the list, once I
select this text item, I want it to place a $0 into another cell.

example: I select from combo box - Teriyaki Chicken, then I want $7.00 to
appear in cell C8 which will in turn be used to calculate a total based on
several other cells.

I just need to know how to take the text from the combo box in cell A8 and
place a dollar figure $7.00 in cell C8.

--

Dave Peterson

Yes, but is your combobox from the control toolbox toolbar or a dropdown from
the Forms toolbar.

Each behaves differently.

But after you try Data|Validation, you'll see that you'll want to use it.

One problem with Data|Validation: You can copy a cell and paste over the cell
with data|validation and it removes that validation.



John wrote:

Thanks, but have not used or heard of data validation. I will have to look
her up and delve a little deeper into my Excel Inside Out book. I think this
one I will need a little more help with. I will try what you suggested and
get back to you for anymore help I may need.

But can it be done with a combo box?

"Dave Peterson" wrote:

How about a slight alternative?

Instead of using a combobox, how about using Data|Validation.

You can set up another worksheet with the values to be chosen in the
data|validation dropdown in column A. Then put the associated price in column
B.

Say you put the data|validation cell in B8.

then in C8, you could use:

=if(b8="","",vlookup(b8,sheet2!a:b,2,false)

Debra Dalgleish has some nice notes about data|validation at:
http://www.contextures.com/xlDataVal01.html

And she has other nice notes about =vlookup() at:
http://www.contextures.com/xlFunctions02.html

John wrote:

I am trying to use a combo box to select a text item from the list, once I
select this text item, I want it to place a $0 into another cell.

example: I select from combo box - Teriyaki Chicken, then I want $7.00 to
appear in cell C8 which will in turn be used to calculate a total based on
several other cells.

I just need to know how to take the text from the combo box in cell A8 and
place a dollar figure $7.00 in cell C8.

--

Dave Peterson


--

Dave Peterson

Thanks I visited the website you spoke of and looks Imay have a winner!! -
Thanks so much for the help. I think I may be able to make this work now.


"Dave Peterson" wrote:

Yes, but is your combobox from the control toolbox toolbar or a dropdown from
the Forms toolbar.

Each behaves differently.

But after you try Data|Validation, you'll see that you'll want to use it.

One problem with Data|Validation: You can copy a cell and paste over the cell
with data|validation and it removes that validation.



John wrote:

Thanks, but have not used or heard of data validation. I will have to look
her up and delve a little deeper into my Excel Inside Out book. I think this
one I will need a little more help with. I will try what you suggested and
get back to you for anymore help I may need.

But can it be done with a combo box?

"Dave Peterson" wrote:

How about a slight alternative?

Instead of using a combobox, how about using Data|Validation.

You can set up another worksheet with the values to be chosen in the
data|validation dropdown in column A. Then put the associated price in column
B.

Say you put the data|validation cell in B8.

then in C8, you could use:

=if(b8="","",vlookup(b8,sheet2!a:b,2,false)

Debra Dalgleish has some nice notes about data|validation at:
http://www.contextures.com/xlDataVal01.html

And she has other nice notes about =vlookup() at:
http://www.contextures.com/xlFunctions02.html

John wrote:

I am trying to use a combo box to select a text item from the list, once I
select this text item, I want it to place a $0 into another cell.

example: I select from combo box - Teriyaki Chicken, then I want $7.00 to
appear in cell C8 which will in turn be used to calculate a total based on
several other cells.

I just need to know how to take the text from the combo box in cell A8 and
place a dollar figure $7.00 in cell C8.

--

Dave Peterson


--

Dave Peterson

OK been trying to do the validation for the combo box replacement. I get the
name in the validation box, and I have created a models tab which has the
same names and the numbers i want associated with the validation. I am having
troubles with understanding where the scenarios and where to tell the
validation to look for the numbers associated with the text on the models
tab. Having troubles with the Vlookup formula to tell it where to look and
how to bring the numbers associated with the validation.

I have:

Validation in cell A8 on tab Proposal Worksheet

I have placed columns of information in the Calculation Tables sheet (tab at
bottom) - A8:A18 is the text I want in the Validation.
B8:B18 are the numbers I want returned to cell C8 on the Proposal Worksheet.
Do I need to create a scenario for this routine? and if so I do not
understand how scerio works and where to place the right information.

I understand a little bit of what she spoke about in the sample excel sheet,
but lost me on the scenarios and vlookup.

"Dave Peterson" wrote:

Yes, but is your combobox from the control toolbox toolbar or a dropdown from
the Forms toolbar.

Each behaves differently.

But after you try Data|Validation, you'll see that you'll want to use it.

One problem with Data|Validation: You can copy a cell and paste over the cell
with data|validation and it removes that validation.



John wrote:

Thanks, but have not used or heard of data validation. I will have to look
her up and delve a little deeper into my Excel Inside Out book. I think this
one I will need a little more help with. I will try what you suggested and
get back to you for anymore help I may need.

But can it be done with a combo box?

"Dave Peterson" wrote:

How about a slight alternative?

Instead of using a combobox, how about using Data|Validation.

You can set up another worksheet with the values to be chosen in the
data|validation dropdown in column A. Then put the associated price in column
B.

Say you put the data|validation cell in B8.

then in C8, you could use:

=if(b8="","",vlookup(b8,sheet2!a:b,2,false)

Debra Dalgleish has some nice notes about data|validation at:
http://www.contextures.com/xlDataVal01.html

And she has other nice notes about =vlookup() at:
http://www.contextures.com/xlFunctions02.html

John wrote:

I am trying to use a combo box to select a text item from the list, once I
select this text item, I want it to place a $0 into another cell.

example: I select from combo box - Teriyaki Chicken, then I want $7.00 to
appear in cell C8 which will in turn be used to calculate a total based on
several other cells.

I just need to know how to take the text from the combo box in cell A8 and
place a dollar figure $7.00 in cell C8.

--

Dave Peterson


--

Dave Peterson

First, if the data|validation list is on another worksheet, you have to give
that range a nice name. See Deb's site:
http://www.contextures.com/xlDataVal01.html#Create
(the second step, especially)

Then in your formula:

=if(a8="","",vlookup(a8,'calculation tables'!$a$8:$a$18,2,false)

Goes in C8 of the proposal sheet.

John wrote:

OK been trying to do the validation for the combo box replacement. I get the
name in the validation box, and I have created a models tab which has the
same names and the numbers i want associated with the validation. I am having
troubles with understanding where the scenarios and where to tell the
validation to look for the numbers associated with the text on the models
tab. Having troubles with the Vlookup formula to tell it where to look and
how to bring the numbers associated with the validation.

I have:

Validation in cell A8 on tab Proposal Worksheet

I have placed columns of information in the Calculation Tables sheet (tab at
bottom) - A8:A18 is the text I want in the Validation.
B8:B18 are the numbers I want returned to cell C8 on the Proposal Worksheet.
Do I need to create a scenario for this routine? and if so I do not
understand how scerio works and where to place the right information.

I understand a little bit of what she spoke about in the sample excel sheet,
but lost me on the scenarios and vlookup.

"Dave Peterson" wrote:

Yes, but is your combobox from the control toolbox toolbar or a dropdown from
the Forms toolbar.

Each behaves differently.

But after you try Data|Validation, you'll see that you'll want to use it.

One problem with Data|Validation: You can copy a cell and paste over the cell
with data|validation and it removes that validation.



John wrote:

Thanks, but have not used or heard of data validation. I will have to look
her up and delve a little deeper into my Excel Inside Out book. I think this
one I will need a little more help with. I will try what you suggested and
get back to you for anymore help I may need.

But can it be done with a combo box?

"Dave Peterson" wrote:

How about a slight alternative?

Instead of using a combobox, how about using Data|Validation.

You can set up another worksheet with the values to be chosen in the
data|validation dropdown in column A. Then put the associated price in column
B.

Say you put the data|validation cell in B8.

then in C8, you could use:

=if(b8="","",vlookup(b8,sheet2!a:b,2,false)

Debra Dalgleish has some nice notes about data|validation at:
http://www.contextures.com/xlDataVal01.html

And she has other nice notes about =vlookup() at:
http://www.contextures.com/xlFunctions02.html

John wrote:

I am trying to use a combo box to select a text item from the list, once I
select this text item, I want it to place a $0 into another cell.

example: I select from combo box - Teriyaki Chicken, then I want $7.00 to
appear in cell C8 which will in turn be used to calculate a total based on
several other cells.

I just need to know how to take the text from the combo box in cell A8 and
place a dollar figure $7.00 in cell C8.

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

Hi

I would like to know how to compute the combo box & normal cell.

For example: -

drop down combo box value 20 x normal cell 10
= result cell

Pls kindly advice me

JOHN Kyaw

"John" wrote:

I am trying to use a combo box to select a text item from the list, once I
select this text item, I want it to place a $0 into another cell.

example: I select from combo box - Teriyaki Chicken, then I want $7.00 to
appear in cell C8 which will in turn be used to calculate a total based on
several other cells.

I just need to know how to take the text from the combo box in cell A8 and
place a dollar figure $7.00 in cell C8.

Assign a linked cell to that combobox and then just use regular excel.

=a1*a2

(where a1 is the linked cell and a2 is the "normal" cell.)

John wrote:

Hi

I would like to know how to compute the combo box & normal cell.

For example: -

drop down combo box value 20 x normal cell 10
= result cell

Pls kindly advice me

JOHN Kyaw

"John" wrote:

I am trying to use a combo box to select a text item from the list, once I
select this text item, I want it to place a $0 into another cell.

example: I select from combo box - Teriyaki Chicken, then I want $7.00 to
appear in cell C8 which will in turn be used to calculate a total based on
several other cells.

I just need to know how to take the text from the combo box in cell A8 and
place a dollar figure $7.00 in cell C8.

--

Dave Peterson