View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AKphidelt AKphidelt is offline
external usenet poster
 
Posts: 461
Default Combo Boxes Calculations

What information do you have in the combo boxes? To reference a combo box
item you need to create a table with the information that is in the combobox
and then use the comboboxes cell link to determine what item is being
pressed. Using the cell link mixed with an Offset formula you can get the
name of the item in the combo box.

"Jupino58" wrote:

I have created several combo boxes on my spreadsheed and I would like a cell
at bottom to calculate the $ value when selecting one or more of the combo
boxes. How do I do that? I can't seem to make them add up!