Drop down lists used to select functions

Resolved · High Priority · Version 2007

Fri 20 Apr 2012, 12:37 Delegate Daniel said...

Daniel has attended:
Excel VBA Intro Intermediate course

Drop down lists used to select functions

Hi,

I was wondering if you could help me. Is there a way of having a drop down list, perferably in a cell or box, which, depending on the option selected within the list, calls a different function.

I.e. The user selects an option from a drop down list and a predetermined cell, say C2, updates with the result of the function called by the list.

Thanks,

Fri 20 Apr 2012, 15:29 Trainer Simon said...

RE: Drop down lists used to select functions

Hi Daniel,

Thank you for your question.

Do you want people to select a range of cells on the spreadsheet and then if they choose Average from a list of values, it will then return the result of the average of those cells?

Alternatively, do you mean if you click on Net Price from the list, it will return the net price created from a pre determined formula in vba?

Regards

Simon

Thu 13 Dec 2012, 11:05 Trainer Cindy said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Thu 20 Dec 2012: Automatically marked as resolved.

Excel tip:

Trace Dependents / Precedents without the blue arrows

Rather than using the toolbar you can press CTRL+] which is the equivelent of trace dependants and CTRL+[ for precendants. Both of these ways though will not show the blue arrows but jump to the cell containing the formula.

View all Excel hints and tips

Drop down lists used to select functions

Drop down lists used to select functions

RE: Drop down lists used to select functions

Will be marked as resolved in 5 days

Excel articles

Excel tip:

Trace Dependents / Precedents without the blue arrows