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,
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
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.
