Solved

Working with Dropbox... Excel 2013

Posted on 2014-04-18
2
471 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
Comment Utility
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 33

Author Comment

by:Mike Eghtebas
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
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…
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
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 …

728 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now