Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Working with Dropbox... Excel 2013

Posted on 2014-04-18
2
484 Views
Last Modified: 2014-04-20
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.
Lookup.png
0
Comment
Question by:Mike Eghtebas
2 Comments
 
LVL 17

Accepted Solution

by:
Karen Falandays earned 500 total points
ID: 40010450
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
kfalandays
0
 
LVL 34

Author Comment

by:Mike Eghtebas
ID: 40011338
Hi kfalandays,

Thank you for the response. What is the mechanics of a dropbox? For example at:
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_28416322.html

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?

Mike
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

839 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