multi choice list /combo

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

I am building a price list with a list of products.Some
products have extras.I see that a list box can have
a "multi" selection but i cant see any way to get an
output from the multi list box.I may need to have the
basic product (which will use the cell link to "choose" a
price from a combo box)with say three extras.....how do i
get my three "extra"prices from my "extra" list..or do i
need a whole battery of check boxes..........
 
Hi Paul!

Depending on the amount of products you have this could be some ideas
to help you in the right direction:

Use an option button for each product and make one combobox that shows
the prices involved with the optionbox that is selected.

It could be done with tables of prices per product and one list for
your combox that is looking up the prices from those price tables. This
list uses the number resulting from the chosen OptionBox to look up the
right prices in the price tables, this will be the Input source for
your ComboBox. (VLOOKUP)

Hope it works out!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

cell value to populate based on changing value in another cell 1
Length of a list in a combo box 4
Multi Select List Box in Access 0
Access Access 2007 - Combo Boxes to break down list in othe combo box 1
Limit to the length of a list in a combo box 3
2 column list 3
Formatting Output Range in Combo Box 2
Combo Box 1

Back
Top