drop down box

Hello you helpful folks, I have an ActiveX dropdown box from which the user may select a date formatted thusly: MM/DD/YYYY. The dates display perfectly in the dropdown list, but once one is selected, it shows up as the Excel numeral code in the box (such as 41548). How do I change this so that...

Hello, Building a spreadsheet (Excel 2010) for a client that wants to track different levels of capacity based on location. All of the widgets are moving and I want the total capacity of new location to be dynamic based on the drop down that is chosen on the widget page. Details: I have two...

Okay, this is my very first post and I might not be asking the right question but here is what i'm trying to accomplish. I'm creating a master list of projects according to employees. So I created a drop down box with employee names and then used the code:=IF('worksheet'!C:C="employee...

OKAY, so after picking around I figured out how to make a drop down box. The drop down box is in cell E3 (EFGH3 if merging matters). I have 21 values assigned to the drop down box which are coming from cells B61:B81. In cells C61:C81 (technicaly CD61:CD81 again, if that matters) I have 1...

i am trying to do the following - cell A1, is a drop down list of the headers of 3 separate lists in cell a2 - i need a formula that would activate a drop down list based on the selected text in cell A1 - example list 1 - BREADS list 2 - CHEESES list 3 - CONDIMENTS wheat...

Hello, I am working in excel 2010 and I would like to create a combobox (list) using the developper ribbon that leverages a list of dates from another tab. I created the combo box and used a named range as the source of dates but I cannot see a way to select unique values only. Is there a...

Hi Y'all! Really simple question for you all, but its baffled me! Using data vaildation, I have created a dropdown box, which works perfectly, however, I used to be able to double click on the cell, and it would drop the list down (rather than clicking on the drop down arrow in the corner)...

Hi Folks: I would like to fire a macro (to unhide specific worksheets) when a selction is made from a data validated drop dow cell. For example, let's assume I have a named range of comprising the names of several fruits" Apples, Bananas, Cantelope etc. One the user selects Apples from the...

Here's what my workbook looks like. It's got 1 master sheet that has 200 rows of information. Each row is for one neighborhood. The following columns B-D list the city requirements, community requirements, home owner requirements, builder requirements, and county requirements for each of the 200...

Hi Everyone; My employer has me doing a project that would really benefit from having a drop down box in a graph. We use Excell 2007...is there a way to do this? Thank you. Janine

HELP! I am trying to create a drop down box with a list of employees "printed names". Then when you choose the printed name have an electronic signature (probably a picture format) automatically post on the following signature line. I am trying to edit a previous employee's method and I...

I work in sales and I'm trying to create a shortcut for my Excel based Product Order Form. I want to create a dropdown box in A1 that has all of my customer names available (ex. Customer1, Customer 2, etc) chosen from the Range B1:E1. After selecting one of the customer names, I want cell...

I am trying to use a dropdown box as a menu system so a user can jump through worksheets froma front page. I have seen lots of snippits of code that appear to do what I want but none seem to work for me. i.e. http://www.mrexcel.com/forum/showthread.php?t=362630&highlight=dropdown I have a...

<TABLE border=0 cellSpacing=0 cellPadding=2 width="100%"><TBODY><TR><TD align=left>I have a Data Validation Box in Cell E7 Worksheet "Report" that references the employees numbers in I3:I80 in another worksheet "Data". I can select the employee numbers from the Data Validation box & it will...

I am wanting to construct a Purchase Order template in excel - by selecting on a machine model from a drop down list (there are multiple models), I would like to copy in a standard set of accessories and costings associated with the model. The Purchase Order may have multiple purchases so I have...

I have decided to reformat an existing worksheet which i created some time ago 2005 and now i require to edit a couple of drop down fields to add new and delete old parts. I can find the source when I go to Data > Validation -and look under the box for Source. However, rather than showing a...

I have a sales contest and everybody has a different partner to sell with each week. I want to be able to have a list of names and in each row select who the current partner is and what they and how many they sold (i,e, salad, soda, pizza, dessert.) with their partner. i would like to only enter...

Hi, I have a worksheet where one of the columns uses a drop down box with 5 values. I would like that when I choose a certain value in the box, the next cell to the right is formatted in a predefined way. I tried to use Conditional Formatting, but apparently my wish is to complex. I guess I...

Could anyone point me in the right direction, please? I have a list with teamnames for my local poolcompetition. And, thanks for asking, mainly straight and 8-ball ;). Now, I use this list as input for a validation drop down list. Now comes the tricky part: for every team i have a list of...

Sorry that my first post should be so obvious, but I've tried searching the forum and can't find exactly what I'm looking for. Here goes: I'm working in Excel 2007 and have a cell with a defined name, that I use elsewhere in a formula. All I want to be able to do is to have a YES/NO drop down...