HELP!!! Beginner here

[axj]

Ive got a slight problem, ive created lists with multi select options, ive linked the cells to a source with numbers. I want to know how to code the selection a user makes, so say a user selects various options from the list, how do i get this to calculate.

 

[babycody]

I am kinda losing what you are trying to ask. I think you either want a Validation List or a Dependent Validation List.

 

[axj]

let me try and explain further. Ive made a list that has some research and development options, its a multiselect list, ive also linked the cells to the cost of each R & D option. How do i get a cell to display the total cost of all the options a user selects.

For the list i created i didnt do it directly in the vb editor, i drew it from the forms toolbar, does this clarify the q?

 

[RAM]

Let me see if I got a solution to your problem straight:

Assuming your research and development options are in column A and the cost in column B, as per my attached sheet, then I want to use a list box from Control Toolbox, not Forms, and C2 is the LinkedCell.

Book8
	A	B	C	D
1	R&D
2	East	$100.00	East
3	North	$200.00	$ 100.00
4	South	$300.00
5	West	$400.00
6
Sheet1

Install the List Box from Control Toolbox, right and select Properties. Type (you need to type) in C2 as the LinkedCell.

Edit: The List Box isn't displayed in the picture above.

Right under that row type in the range of your development options as the ListFillRange. In my case it would be A2:A5.

Exit the Design Mode by clicking on the top left button (Design Mode) for that toolbox. If you later need to alter the range select Control Toolbox, right click, select Properties and enter Design Mode.

EDit: Select the range of research options and the cost (A2:B5 in my case) and click in the Name Box (next to the Formula Bar), (where you see C3 in the above example) and type in the name of that range. I called my range Research, as per the formula in C3.

The formula that returns the cost is in C3.

Hope This Helps

RAM

 

[axj]

thank you, this helped, but i cant seem to get it to work with multiselect lists, how can i do this??

 

[RAM]

Please explain for me what you mean by multiselect lists and where do you get the data from?

RAM

 

[axj]

Multiselect = when the user can select more than one item on a list and when the multiselect property has been changed to 2. so say if the user on the r&d selects more than one option how do i link it the figures to it, display the options in another cell and calculate them?

 

[lenze]

Just a thought, but try playing around with checkboxes instead. When a Box is checked, it's linked cell will be TRUE. In the cell next to the linked cell for that item, enter the price.
Place all your linked cells in a column with prices to the right to form a table. Use SUMIF to get the total for the checked boxes. NOTE: The linked cells and table can be on another worksheet.

HTH

lenze

 

[RAM]

lenze,

You do have a good point there, but I'm turning to you for a question on my behalf. axj mentioned he was using a List Box from Forms. That list box has the option Multi as Selection Type under the Control tab in Format Control. That selection allows you to enter several options from the list, but then what? Does it take codes to go on from there?

RAM

 

[axj]

thanks that helped alot, i switched to check boxes and its working