HELP!!! Beginner here

axj

New Member
Joined
Nov 30, 2005
Messages
21
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.
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
I am kinda losing what you are trying to ask. I think you either want a Validation List or a Dependent Validation List.
 
Upvote 0
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?
 
Upvote 0
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
ABCD
1R&D
2East$100.00East
3North$200.00$ 100.00
4South$300.00
5West$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
 
Upvote 0
thank you, this helped, but i cant seem to get it to work with multiselect lists, how can i do this??
 
Upvote 0
Please explain for me what you mean by multiselect lists and where do you get the data from?

RAM
 
Upvote 0
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?
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,214,775
Messages
6,121,498
Members
449,034
Latest member
Raygers

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top