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