Solved

Working with Dropbox... Excel 2013

Posted on 2014-04-18
2
480 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 33

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
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 how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

778 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