• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 500
  • Last Modified:

Working with Dropbox... Excel 2013

Working inan existing workbook, I have dropbox 1 (please see the attached image). This dropbox populates cel Lookup!B10 and also stores its value in a named-range called "CurrMthCol".

Q1: How does this work? I cannot find VBA associated with this dropbox. Is it different in Excel 2013?

There is need for two additional variables (named-ranges) I need to create to store MthFrom and MthTo to be used later. If I learn how dropbox operates then I can do the same for the other two.

Thank you.
Mike Eghtebas
Mike Eghtebas
1 Solution
Karen FalandaysTraining SpecialistCommented:
Hi eghtabas,
Can't tell from the image, but it looks like a data validation rule. To check to see, go to the home tab nd click to Find and select...data validation. This should reveal any cells using data validation rules. From here you can go to data validation settings and update the source to add new data

Let me know if that does the trick
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
Hi kfalandays,

Thank you for the response. What is the mechanics of a dropbox? For example at:

I have a question where the dropbox at cell Sheet1!D2 puts "10" into cell Formulas!L10.

How this works? There is not event in the code window?

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now