LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Ed Ferrero
 
Posts: n/a
Default List box setup, placement, and functionality

Hi Ladybug726,

Not sure I understand everything you are trying to do, but here are some
comments.

Col A - Parts, Col B - Qty, Col C - Cost-1, Col D - Tax, Col E -
Multiplier,
Col F - Subtotal, and Col G - Cost-2 (or Total). I have formulas in Cols
C-D-F-G to calculate. Column E - Multiplier, is where I need a list box
to
appear so the user can tab to that cell and select the percentage from the
list box and have that number inserted automatically into that cell, then
the
next cell calculations will be done automatically, as well. (If, of
course,
I have done the formulas correctly.)


There are actually three types of list boxes that you can embed in a
worksheet. I will take a guess and describe wht=at I think you need.

Lets' say your list is in Sheet2 range A1:A4, and the data you describe
above is in Sheet1.
Enter the following values in Sheet2 range A1:A4
0.1,0.2,0.3,0.4 Format the range as Percentage.

The easiest listbox for your purposes is the cell validation list. To use
this, select some cells in Column E - Multiplier in Sheet1, then use the
menu command Data - Validation...
Change the validation criteria to List. Then click on the source box and
select the list range from your worksheet (or just type =Sheet2!$A$1:$A$4).
Click OK.
Now, if you select one of the cells that you have applied Validation to, you
will see an arrow - click on this to see the list box. You will need to
format the cell as Percentage to see the correct rresult.
Copy the cell down as far as you need.

Ed Ferrero
http://edferrero.m6.net/


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 08:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"