[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Excel dropdown list choice used in a formula

Posted on 2012-08-13
Medium Priority
Last Modified: 2012-08-23
Using Excel 2007.  Want to use a combobox on a worksheet for users to choose a month (January, etc.).  Their choice should be stored as a text variable "January" for use in an existing formula in the same worksheet.  The formula should execute when they make their choice from the list.  Can someone help me construct the solution using VBA?  I'm a newbie with VBA.

Thank you, experts!
Question by:DetersLaw
  • 2
LVL 50

Accepted Solution

Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 2000 total points
ID: 38290090
any particular reason you want to do this with VBA and a combo box? You could use Data Validation instead with a list of the 12 month names.

See attached.

cheers, teylyn

Author Comment

ID: 38292604
That works nicely, Teylyn.

But I'm afraid the workgroup who will be using this workbook have changed how they want this to work:  They want to rename a worksheet to the name of a month and use the updated name in this formula, which is on a different worksheet in the same workbook.


Said another way.  When they change then name of the July worksheet to August, the formula should change along with it.

Thanks, and apologies for changing the requirements.  I am open to a variety of methods.
LVL 50
ID: 38308985
If a formula refers to a cell in another sheet and the sheet gets renamed, the formula will reflect the new sheet name.

If that is not working for you, please post a file with some examples.

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question