dropdown box

I am trying to use two seperate dropdown lists to select a specific value in a table of set values. The first drop down will select the row and the second will select one of two columns. I have the data validation lists ready to go but it looks like the main hangup I'm getting is having the...

Hello, Is it possible that selecting an item from drop down should enter certain text in a cell ? For example in cell "L7" there is a drop down with two items 1) pay due 2) Bill Selecting (pay due) should enter following text "Payments are due from the dealer, requires special attention."...

Hi This is my first post. I'm wanting to know if there is a way to auto fill a drop down box. For example I have a drop down box in Cell A1 which has an input range of $E$1:$E$4 and a cell link to Cell A1. I now want to have another drop down box in Cell A2 with the same input range and but...

Good morning Mr Excel, I am trying to create a formula that allows me to have different options populate a cell depending on the content of another cell. I think i have done this before but cant remember the finer points, =IF($C$7="Select Axle...

Hello, I am attempting to use an ACTIVE X combo box. to deliver the desired function. What i would like to do, is make a selection from the drop down combo box, and depending on what i select, have it populate other fields. PLEASE HELP!!!

Hello, I have this code: Code: Sub comments1() With ActiveSheet With .Rows("180:186") .Hidden = Not .Hidden End With With .DropDowns("Tag1_1") .Visible = Not .Visible End With With .DropDowns("Tag2_1") .Visible = Not .Visible End With End WithEnd...

Hello there, I hope you are all well. I have a project file that contains a table with employee names. I have a formula on the 1st column of the table (reference) that will be visible if the "Available?" column is set to "Yes". I want to send an email to one of the employees that shows the...

I think I'm almost there, just need to find a way to point the filter at the drop down box. My macro code appears below. The macro works when I use the commented out line which points to the value of cell e2. The problem is, I want it to point at my dropdown box instead. I think I just have the...

Good Morning/Afternoon, In L3, I have a dropdown list of dates by year (2005-2012). The formula I want to use for Z3 will add 5 years to the current displayed date in L3. Right now, I have that listed as =SUM(L3)+5, but want to nest an ISBLANK statement in there for when L3 does not have a...

Hi all, I have a dropdown box containing text strings. How can I use the selection from a combo box as part of a formula? So for example I have a spreadsheet that is set up using a search term 'media', I want to select something else from the list e.g 'arts' and I want all of the references to...

Hi folks i'm looking for a bit of help using macro's on Excel 2010. what i'm trying to do is create a macro that will copy a range of cells from one sheet to another depending on a option being selected from a drop down box. I've tried to use formulas but without success. sheet 1 contains a list...

hey I have some code for a set of conditional dropdown boxes. Everything works but I have to manually run the macro to get the values in the drop down box to change. So what I need is for everything to automatically refresh whenever a box is changed, any suggestions? Private Sub...

Hey guys, I am wanting to select a value from a drop down list (sheet 2) and have all of the occurances of the same names populate the table on sheet 2. the raw data is on sheet 1. Below is a link to my excel file which will hopefully help out with explaining what I'm trying to achieve...

How can I create a drop down menu, or a button @ the top of the spreadsheet that if selected will display a different data sets? So eg. If option A is selected it shows Operational Cashflow, if option B is selected it shows Investing Cashflow and if option C is selected it shows Financing...

Hello, I am putting together a form, and I would like that if the use selects a category in a drop down box, then it limits the options in another drop down box as a result of their choice. You see this often on auto insurance quotes, where if you select the make of the car as FORD, then...

All, I have drop down lists that I use to assign the employees at work to complete certain daily tasks. I am wondering if there is a way for the list to update and eliminate the items I have already assigned from the dropdown menu so that I can see only the tasks not assigned as I progress...

Hello, I am redesigning a User form into a spreadsheet "form" controls. I used below "code 1" to dynamically populate drop-down list (combo box) with tab names as they are created with my tool (tab names i.e. tab1, tab2, tab3 etc) It was working fine on a User Form used with "Private Sub...

Hi there, I am having a drop down box in A2 with a lot of choices to choose from. Is it possible that when I for ex type "App" it will automatically take me to the nearest match in the drop down box Regards