Dependent Drop Down Forms

Aug 12, 2007

I am trying to put together two combo boxes, Combo1 and Combo2, the content of Combo2 will depend on the selection made in Combo1, for example Combo1 will have 10 items, once an item is selected Combo2 will have different sub selections relating to that item. I know you can do this via Validation, but the problem with that I have about 4000 options in the combo1 and about 60000 in the second, here is the structure of my data:

First Option /Second Option
Option1_____1.1
Option1_____ 1.2
Option1_____ 1.3
Option2_____ 2.1
Option2_____ 2.2
Option2_____ 2.3
Option3_____ 3.1
Option3_____ 3.2
Option3_____ 3.3

My ultimate final result should look like this, two drop down menus once Option1 is selected second drop down form should display these options:

Option1 /_____ 1.1
____________ 1.2
____________ 1.3

see attachment for complete clarity

View 9 Replies


ADVERTISEMENT

Dependent Drop Down List With DEPENDENT DEFAULT VALUE

Jan 22, 2010

Situation:
I have two drop down lists 1) Country and 2) States/province

Country has list: [US, Canada]

If "US" is selected, [Arizona ,Florida, NewYork] is listed in the 2nd drop down list
If "Canada" is selected, [Alberta, Ontario, Quebec] is listed in the 2nd drop down list

Scenario:
First, I select "US" and choose the states to "Florida"
Next I change the country to "Canada" and forgot to choose province
Then, the 2nd dropdown list is changed to [Alberta, Ontario, Quebec],
BUT the current value is still "Florida"

Probem:
Now I have "Canada" and "Florida" selected in the sheet

Question:
If the primary list is changed, can I make the 2nd drop down list to show a default value (e.g. blank or the first entry i.e. Alberta)?

View 11 Replies View Related

Drop-down Lists In User Forms

Mar 14, 2007

I am making a user form so that others can enter their data into a database.
In some of the fields I want to have a drop down list that will contain both all the options from a generic list, and any other items that have previously been entered into that field. For example I have a generic list of components but someone may feel that none of those listed describe their component so they will add a new one, I want this new one to then appear within the drop-down list for the next user,

View 9 Replies View Related

Dependent Drop Down Lists ...

Jul 6, 2009

I have been searching on this for a little while now but have not been able to find a solution to my problem. I have been asked to create a series of dependent dropdown lists using excel so that we can use these for inventory imports into a asset system. The catch on this is that nobody here really has any idea on how to make these dependent lists reference each other correctly. The reason for that is because the fields all have spaces in them and I do not know how to get a list name with a space in it or to create the proper translation for it. An example of this would be something like what I have written in below ....

View 13 Replies View Related

Cell-dependent Drop-down

Oct 12, 2009

Say in A1 i have either Yes or No, in B1 i have a dropdown validation from a list if A1 is Yes and "n/a" if A1 is no.

I thought if i renamed my list validation to "Yes" and labelled "n/a" as "No", then using =INDIRECT(A1) as my list validation would do the trick.

View 2 Replies View Related

Validation Drop Down, Dependent Upon Another Cell Value

Apr 21, 2009

I am trying to create validation drop down list for a cell, however I want different drop down lists which are depenent upon another cell.

in Cell A1, I want the options "A", "B","C" etc
If cell A1 = "A", then drop down validation for cell A2 = 1,2,3,4,5
cell A1 = "B", then drop down in cell A2 now equal 6,7,8,9, 10
cell A1 = "C", then drop down in Cell A2 now equal 11,12,13,14,15

View 4 Replies View Related

Semi-dependent Drop Down Lists

Jul 30, 2009

I'm trying to make a number of cells dependent to a drop down list. However, these cells would also be drop down lists and while they'd show a value automatically determined depending on the drop down list, the user would still be able to choose another value.

Aluminium
Coated steel
SS304
SS316

This would be my initial drop down list.

In the same sheet, I could choose the materials for the machines shaft, fasteners, anchors, chains, sprockets, nozzles, etc. These materials would be, again:

Aluminium
Coated steel
SS304
SS316

in 90% of the cases, having the machines frame at SS304 would mean the rest of the materials would also be SS304. However, depending on the needs, the anchors could be SS316. So basically I'd like that the options all be in the same material as the frame, but with the possibility of choosing another material through a drop down list.

View 4 Replies View Related

Dependent Drop Down List Keeping Old Value

Apr 11, 2008

My problem is a dependent drop down list that keeps the previous value when a different value is picked in the first drop down list. The dependent drop down needs to change to empty/blank.

The first drop down list is in cell C3.
The dependant drop down list is in cell C4.
The source in C4: =INDIRECT(VLOOKUP(C3,allnames,2,2))

I had a look at various answers on the internet but somehow cannot get it to work (and that is more of a reflection of my own skills than the writers of those answers!).

View 9 Replies View Related

Reset Dependent Drop Down List

May 10, 2007

The only thread I could find on this topic was not resolved. I want to reset the value of a dependent drop down list (in H3) to the first valid choice when F3 is changed.

I have the following code that initially worked but no longer does.

Private Sub Worksheet_Change(ByVal Target As Range)
On Error Goto errHandler
Dim DLRng As Range

If Not Intersect(Target, Me.Range("F3")) Is Nothing Then
If Target.Count > 1 Then Exit Sub
Application.EnableEvents = False
Set DLRng = ActiveWorkbook.Names(Target.Value).RefersToRange
Me.Range("H3").Value = DLRng.Offset(0, 0).Value
End If

exitHandler:
Application.EnableEvents = True
Exit Sub

errHandler:
MsgBox "Could not change dependent cell"
Goto exitHandler
End Sub

I now get the error message ""Could not change dependent cell" every time I pick a different item in the drop down list in cell F3. If I remove the error handler I don't get the error and the code simply doesn't work.

View 9 Replies View Related

Create Default For Dependent Drop Down List

Feb 18, 2010

I'm using dependent drop-down lists. In the first box the user can choose a color which drives a set of options in the second box. (e.g. User selects "Red" and in the second dropdown they can then choose "Red A", "Red B", "Red C", etc.). Right now, if you select "Orange", it will still show "Red A" from the previous selection until the user selects the dropdown in the dependent box to refresh the list of options. Is there a way to make it so that second dropdown box will default to "Orange A"?

I tried writing some code to do this, but I can't seem to make it work. I've attached my file.

View 7 Replies View Related

Dependent/Linked Drop Downs In Cells

Apr 29, 2008

Now he has another task that I am not having any success with. He has asked if we can make an Excel spreadsheet that allows us to access a list of customer units from a drop down menu which is in another workbook, and once you choose that particular unit, another drop down menu will allow only those customers who are assigned to that unit to be selected from that sub-menu. I hope that makes sense.

Say customer A1 (we will call him Delta Co, 2-1 Aviation) is selected from this first drop down menu (which I haven't figured out how to make yet either). Then this selection would access another worksheet in that other workbook with a new drop down menu with only the four customers in that unit. As an example we will use the names SSG Wilson, SGT Jackson, SFC Jones, and SGT Phillips.

So when the Supply Tech here opens the spreadsheet, the first drop down menu, he will select Delta Co, 2-1 Aviation. Then the next menu will only show four names, and he will select SFC Jones.

Once we get this going, I may be able to figure out the other things the commander wants, if not I will be back.

View 9 Replies View Related

Refine Values In Dependent/Linked Drop-Downs

Aug 24, 2009

to make the user experience better by inserting the " Stock Search" sheet to speed up the process. The spreadsheet attached is a simplified version of the current version, where it would normally have many many more sites, areas and models of cars. The existing process means the user has to trawl through the sheet where they are only interested in what sites in their area has stock. I can not change the format of the "Red" and "Yellow" sheets so hoping to insert another sheet to do the work.

I am hoping to have on the "Stock Search" sheet a few drop down boxes.

The user will select

1. Area
2. Type of Colour (the type of colour selected should link with the sheet name in effect, so only stock within the "Red" sheet will be shown if the "Red" colour is selected from the drop down box)
3. Model of Car

This will then give the resulting Store/Stores with stock (value 1 or above) with those conditions met which is showing in the relevant sheet

So as per the attached sheet, if a user selected Area "South West", "Red", "Renault Megane"

then SO10 Clifton 1 and SO15 Yeovil 3 would be shown in a list.

View 5 Replies View Related

What Its Called When You Have Drop Down Menus That Correspond With Other Drop Down Me

Nov 22, 2008

what its called when you have drop down menus that correspond with other drop down menus.

View 2 Replies View Related

Populate Drop-Down Based On Another Drop-Down Choice

Oct 25, 2006

Here is what I'm trying to do:

I have 4 sheets:
1 called main
1 called states
1 called counties
1 called people

On "main" I have 1 drop down box and 1 cell:

the drop down lists the states from "states" sheet
the cell, which i would like to have as a drop down is supposed to be listing the counties in the state selected from the 1st drop down. right now it is setting the value to TRUE for testing purposes.

then when the county is selected, it will display the people in that county listed in "people". So far I can only get the 1st drop down to list the states. that's the easy part. i need to getting the counties to list in another drop down based on what state is selected.

View 2 Replies View Related

Populate Drop-Down Based On Another Drop-Down Selection ...

Dec 5, 2007

Im a fairly basic VBA user who has just purchased the code for J-Walk's Enhanced Data Form.

On other threads in this forum I have noticed a lot of people asking how to make the contents of one drop-down box dependant on the selection in another. I am trying to do the same thing but with the criteria section of the EDF form.

Is this possible? What does give me hope is that a simple Autofilter - whilst not as aesthetically pleasing, does the job well.

View 3 Replies View Related

Populate Drop-Down Based On Another Drop-Down Selection

Aug 7, 2008

Currently I have columns fixed or assigned to the names of insurance providers/companies.

In each column below the name of the Insurance Company, a combobox containing the plans that company offers. Choose a plan, and the rest of the column is filled in using vlookup.

Now to save space, IE opposed to having 13-15 columns one assigned to each Insurance Company/Provider. I am looking to have only 3-5 columns with a first initial combobox in which one chooses the Name of the Company/Provider, and in turn populate the original combobox and vlookup functionality I already have built in.

Here is an example of what I am working with.
[url]

View 3 Replies View Related

Tab Order In Forms

Jun 11, 2008

I would have like a chance to be able to remove the apparent potenitial dangerous problem from the thread below and not close it after 10 mins. I'm not on the site permenantly and keep dipping back in eveynow and again. I dont know what the issue is as when I open the file up I dont get any error messages. I have tried this on my machine using Office 2003 and Vista also another PC using Office 2003 and XP

[url]

The only error I get is a message saying Disk or Network error, when testing it on the XP Machine this is because doesnt have access to the Database it sends the data to.

View 9 Replies View Related

Times In Forms

Mar 16, 2009

I have a table in Excel which holds Names, StaffID & Times for working (Start & Finish Times)

When I open the form, it shows the times as a Number how can I get them to show as a Time (hh:mm)

View 6 Replies View Related

VBA Report With Forms

Dec 5, 2009

sometimes pivot tables won't give me the details I want the way I want. any time my boss asks me for a monthly report I have to do everything manually from the pivot table and insert the data on another table where I put the filteres data. I want to be able to get a monthly sales report per store that will populate itself in a daily basis, I also want to be able to select a store, style, size and date from a form in Excel and see the report in a sheet. Aproblem that I have found in order to use the size as a parameter is that the size comes in the same line as the item description and do not know how to make excel to check just for the size in the description field.
The attached file contains sales data for a better understanding of my case.

View 14 Replies View Related

Combobox In Forms

Oct 13, 2008

I have created a form which is called up via a macro and then shows a combobox which contains the names of the worksheets in the workbook.
I am trying to enable the user to select one of the worksheet names from the combobox and then store that name (the book does not have fixed sheet names) and continue with the original macro using the stored name.
I just can't figure out how to use the selected name in the original macro.

View 9 Replies View Related

Numbering In Forms

Dec 29, 2008

I have created a form to input parking ticket data to a spreadsheet, it all works exactly as i want it to, but i really need it to tell me the next available number or empty line, so i can use that for filing and audit purposes, ideally i would like it to do sequential numbering, but i've been looking for weeks and cant find a soloution, i have basic knowledge of VBA and i'm really struggling with this,

View 9 Replies View Related

Drop Down List Which Returns Values Based On What Has Been Selected In The Previous Drop Down List In The Adjacent Cell

Mar 19, 2009

I'm trying to create a drop down list which returns values based on what has been selected in the previous drop down list in the adjacent cell, e.g. if 'Apples' is selected in the previous cell then you should only be able to select from 'Gala, Granny Smith', or if 'Oranges' is selected you should only be able to select 'Seville, Blood Orange'. Is there a formula which would do this, or can I use a pivot table somehow? I'm totally stumped.

View 2 Replies View Related

Selection From One Drop Down Creates New Drop Down

Mar 1, 2007

In the attached example I am trying to get the selections from one drop down to gnerate available selections in the next. The first drop down is the door style. This then needs to generate the possible drop downs in wood species. This then needs to generate the possible drop down in available stains. this then needs to generate the related door factor....

View 9 Replies View Related

Listbox And Textbox On Different Forms?

May 13, 2014

I have a listbox on userform1 with multiselect and i am trying to populate the selection into textbox1 on userform2.

View 6 Replies View Related

Copy User Forms

Nov 7, 2008

So I have a work book with a number of user forms. One form I have completed has several navigation buttons (previous, save, next......) a couple of drop downs and a "tabbed" (pages) area with a text box on each. I think I finally have it looking (and working) the way I want. The issue is I need 12 more that are Identical (different text - but layout and code is the same) To make them look and work the same how can I copy the one I have correct? Is Export/Import the way to go? Does that bring all the code?

View 3 Replies View Related

FORMAT In VBA On User Forms

Nov 18, 2008

Excel 2003

VBA on user forms

View 5 Replies View Related

Calling Forms Using Variables

Nov 9, 2009

I would like to know if it is possible to display a form using a variable containing the form name rather than the form name itself, I have tried everything I can think of and cannot make it work. I know I can use CASE SELECT but I have a large number of forms involved and would like to use a variable name if possible.

View 4 Replies View Related

Copy Forms Checkboxes

Aug 25, 2012

I have checkboxes in N85:N100 and O85:O100. When I use the following code, it gives the same link in N85 and O85. How can I put a specific rannge so that it will only do N85: N100 and then do O85:O100.

Sub change_forms_checkbox_links()
Dim mychkbox As CheckBox
Dim wks As Worksheet
Set wks = ActiveSheet

[Code]...

View 4 Replies View Related

User Forms / Menus

Nov 21, 2006

I am trying to graduate out of the crayon age of menus on a worksheet, to using a User Form Menu. Problem is, I don't understand how they work. I've created a test program using a simple form with an option button, a combo button, and a command button. The goal is if the option button is true, it places the color selected in the combo button on the worksheet. Here is my code, what am I missing to make it work?

Corrected code from my original request

Module 1

Public ClrCd As Integer

Sub OpenForm1()
UsrFrm1.Show
End Sub

View 9 Replies View Related

Forms - Scrollbars & Multipages

May 8, 2008

1) I have a scrollbar that gets set to UserForm1 height.... yet, if the form is taller than the page, it won't let me scroll down past what I can see on my computer screen... what would be the cause of that? I get a blinking black light on the scroll bar as well so there must be something I need to fix with that

2) In UserForm1, I have a multipage form with a page called Accounts... I am adding check boxes to it with code... right now it is adding it to the far left in UserForm1... what is the syntax to run my check box loop to populate the Accounts page in the Multipage form?

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved