populate a drop down list with commands

S

sjbegley

I would like to populate a drop down list with commands.

Command A - return the sum of a specified cell
Command B - return the sum of a specified cell and double its value (x2)
Command C - return "N/A"

We only need to specify two cells (the source and the result) but it is the
coding and the functions that are unfathomable for me.

Please assume I know nothing about VB or VBA - you won't be far wrong!

Thanks
 
S

sjbegley

Can ANYBODY help me with this please? I am really struggling with it.

I am not sure if this makes any difference but the source cell contains the
=SUM formula at the bottom of column of values. It's the sum value I want
to process with commands A and B; Command C would signify a not applicable
command.

I have worked out how to build a list from list validation but I can't get
any further...

HELP!
 

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

Drop down list control value in vba 2
Link a text box based on drop down box with four options MS Word 365 0
Drop down lists in seperate columns 5
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1
drop down list 1
Help with creating drop down 1
How to dynamically change the list in drop down list based on thevalue of another cell? 1

Top