Populate A List From A Value In Another List Or Combo Box
Aug 10, 2009
I have a worksheet in which Col. A contains the names of London boroughs and col. B contains the name of each Ward in that borough. I'd like to create a list (or combo) box showing all the London boroughs, and a second list (or combo) box which will show all the Wards for the Borough selected in the London list (combo) box. I'd also like the option to be able to select all the Wards for the borough selected so that they can be used in a chartgraph.
View 2 Replies
ADVERTISEMENT
Jan 18, 2007
I've created a user form (click button on 'main page' to display). Combo Box called 'Last name' gets populated with all second names from the sheet 'Staff'
When a user selects a second name from the drop down list, I would like excel to automatically update the list box 'First Name'. Also, If a user changes the first name or Last Name, this should be saved
View 9 Replies
View Related
Jun 11, 2013
I'm creating a spreadsheet to keep track of my costs of production in an online game. Within the game there are a range of spawned resources that appear for only a short time before being unobtainable these resources have specific types that is shared between multiple spawns of the resource but each resource spawn has a unique name.
My first worksheet lists all the resources and their various qualities and the later worksheets are meant to allow me to choose from a list resources matching the requirements of the item I'm looking to craft. The example i have shown in the second picture requires Tatooinian Fiberplast and Lokian Wild Wheat to craft so in the Chosen Resource column I would like to have a drop down list allowing me to select the named resource type i would like to use - for Tatooinian Fiberplast the only thing on the list should be Omnitwixi and for the Wild Wheat it should show Fizi and Krad
[URL]....
[URL]....
I am aware there are people with more pressing problems than computer games and as such
View 7 Replies
View Related
Jun 7, 2006
i have a list in a database which is populated by a textbox on a userform. the list is money. i want to keep a running total which is then recorded in a textbox on a user form. when i have tried to do this the total does not drop down so i cannot populate the list.is there some code i can use to do this or do i have to drag the total further down the column.
View 3 Replies
View Related
Jan 10, 2007
I have a form with a combo box. Is there a way, if a user enters something not one of the current choices, to have that choice added to the list?
View 9 Replies
View Related
May 18, 2009
I have a list box with a list of text. What i want is if the user selects one of these text values in the list it opens up a user form.
View 9 Replies
View Related
Jan 14, 2014
Basically i have a data compilation of the sales for each sales agent for each month. I'm trying to create a simple, controlled table where the user can just choose which Employee(List Box) and the Month(List Box) and it will display their TOTAL Sales, the catch is TOTAL sales will be the sum of sales from previous months up till the chosen month.
Example below.
How do I go about inputting the function in the TOTAL cell?
JanFebMarAprMayJun
Kelly 3 4 2 1 6 7
Sha 1 3 2 4 2 6
Agus 8 6 3 6 0 9
EmployeeKelly
MonthFeb
TOTAL:7
View 8 Replies
View Related
Jan 22, 2009
I would like my combo box list to change base on the value of A1. That is, I have its input range being B1:F1 - "Year 1", " Year 2" etc.
Example:
-If cell A1 is the value "10" then the combo box default list item would be
"Year 1" (which is cell "B1")
-If cell A1 is the value "20" then the combo box default list item would be
"Year 2" (which is cell "C1") ETC...
View 3 Replies
View Related
Apr 24, 2007
I have a list of combo boxes embedded on a worksheet and I would like to have them accessible through an array. I am an old VB 5 coder and this was a method I used very often and found it to be quite the time saver, but I cannot find a way to do this in excel.
View 9 Replies
View Related
Mar 27, 2009
Trying to create a drop down list using a combo box. Then, when i select an item on that list, it will bring me to the range of cells where that information is stored.
Is that possible? I have no VBA experiance at all.
View 9 Replies
View Related
Dec 1, 2007
I use ComboBox to add items to the ListBox in userform
I am tring to loop through the ListBox to check each name in the ListBox, so ifthe name chosen by the ComboBox exists in the ListBox then donot add it,
but both codes do check the number of the item in the ListBox.
I need to check the name of the item?
With ListBox1
For i = 1 To ListBox1.Value
If i = ComboBox1.Value Then MsgBox "u cannot add this item"
Exit Sub
Next i
For i = LBound(ListBox1.List) To UBound(ListBox1.List)
If i = ComboBox1.Value Then MsgBox " u cannot add this item"
Exit Sub
Next i
.AddItem tot.Value
.List(.ListCount - 1, 1) = ComboBox1.Value
End With
View 9 Replies
View Related
Sep 5, 2008
I'm trying to figure out how to activate a macro from combo box or list box.
But no success.
I have a list of names:
AAA
BBB
CCC
111
222
333
That I can view through the combo box.
I have created a list of macros, that carry the same names,
AAA
BBB
CCC
111
222
333
The Q is: how can I link each name to its own macro?
so when chosen, will activate the macro?
View 12 Replies
View Related
Feb 17, 2009
Leith was kind enough to to put a great combo box together for me (see attached). Is it possible for the drop down list to open on type or do you always have to click the arrow?
View 3 Replies
View Related
Aug 7, 2007
I need to define a specific calendar quarter and year, and want to do so using a combo box for the quarter (e.g. 1st Quarter, 2nd Quarter, 3rd Quarter, 4th Quarter) and a list box for the year (so the user can select any year desired).
The selections in each item should then somehow define the quarter's date range so I can use it in my SUMPRODUCT calculations.
Example:
User selects '1st Quarter' from the Combo Box
User selects '2004' from the List Box
CurrentQuarter range is somehow defined to equal 1/1/04 through 3/31/04.
If this isn't possible, then perhaps two ranges can be defined based on the user's selections:
QtrStart is set to 1/1/04
QtrEnd is set to 3/31/04
View 12 Replies
View Related
Oct 31, 2009
I have a combo box, from the control toolbar, that I have populated with a named range in the properties of the combo box. The items in the named range vary when an earlier combo box is selected. There are always at least 2 values populated in the named range, but can be as many as 22 values. What happens is when there are only 2 items in that range, the drop down list from the combo box shows 20 blank lines! I have been searching for how to "ignore empty cells" in this range, but cannot find it. The empty cells are always before and/or after the populated cells, if that helps. The range is updated via VBA, not formulas, if that is helpful as well.
View 9 Replies
View Related
Nov 14, 2008
I trying to do a sheet with one combo box (dropdown list) where I want the user to be able to choose "add rows" to make more boxes appear. My idea to solve this was to put all the boxes in the sheet, and then create a macro that either hides or shows the rows with the extra boxes. Now I have a problem that hiding the rows just does that, and only that. The rows disappear, but the combo boxes stay visible (but ends up on top of eachother).
View 2 Replies
View Related
Mar 4, 2009
I need a list in my form, simple "Name/Number" list (only two options) but i don't want it to refer to any cell in the worksheet.
I want to input a text in a textbox and with the selection in the list above i want to have multiple choices at how to approach the text (if i input a name i want it to be different than if i input a number). All the info i came up on the web refers to lists made upon a range of cells.
How can i make a list without involving ranges of cells?
View 6 Replies
View Related
May 29, 2006
I have been trying to make a combobox for which the list is a named range. However, this range needs to be transposed. ListFillRange doesn't seem to let me transpose the list first. I've tried transposing the list somewhere else first and then adding it, but it seems to want a range as opposed to a reference to a range. I'm so confused now. This is the basic code that I wish would work.
ActiveSheet. OLEObjects.Add(ClassType:="Forms.ComboBox.1", Link:=False, _
DisplayAsIcon:=False, Left:=253, Top:=472, Width:=117, Height:=20). _
Select
Selection.ListFillRange = "=transpose(Stream_Data!StreamList)"
While I'm at it, could someone explain to be how to refer to a combobox. ie. when you create it, you don't name it so how can you refer to it. That's why I have used the selection tool above to add the list.
View 3 Replies
View Related
Jun 9, 2007
I want to create a form and use VBA to make a combo box list all the sheets in a book. Is it possible to select multiple entries like in HTML? I would like the user to be able to select the sheets they do not want to delete before a macro runs.
View 2 Replies
View Related
Dec 5, 2007
I'm creating a sheet that takes three Validation Lists into account. The first two lists are based on named regions. The third list uses the first two lists to narrow a search down so that the user can pick what they want from a smaller selection. I'm using the code from Contextures.com to allow the user to double click the validation list to pop up a Combo Box. This allows me to show more than 8 selections at a time and also gives a little freedom on font and font size.
http://www.contextures.com/xlDataVal11.html
Since the third list is not based on a named region but rather code to compare the two previous lists, when I double click the third validation list a blank combo box pops up. it possible to pop up what ever lists are in the validation boxes.
This is the code that I have in the third validation box which States "The Source Currently evaluates to an error" but works fine for some reason. =OFFSET(CategoryStart, MATCH(B4, CategoryColumn, 0) - 1, IF(A4 = "Description", 2, IF(A4 = "ExtDescription", 3, IF(A4 = "PartNumber",4))), COUNTIF(CategoryColumn,B4), 1)
I tried making a named region that was based on the code, so that the list could change as the user selected different options from the first two lists. This gave me the same problems as I had before.
View 2 Replies
View Related
Aug 1, 2009
how to add drop list box or combo box in this yearly time sheet so every employee has his own record in this time sheet so when ever i select name from drop list all info changed, i did include table in sheet 1 as an example.
View 4 Replies
View Related
Jan 18, 2009
In my attachment, I have a worksheet where I need to pick a rating from a combo box or list (Expert, Leading, Applying, Learning, Under Performing). I will be picking this rating 10 different times on this worksheet and the selections will not be the same in all cases so the definition I need won't always be the same.
I would like to return the definition (definitions are detailed on another worksheet, Data Elements) to the cell to the right.
I've tried IF statements but when I make one selection from the combo box, all the combo boxes select the same thing. I've also tried vlookup but can't figure it out and can't find an explanation in layman's terms.
View 2 Replies
View Related
Sep 30, 2012
I am preparing a template for which I need a combo box. Becaue it is a template I can't have this combo box any specific input range. Because I won't know how long the data column (that wiill be used for input range) will be.
Also the data column will have many duplicates but the combo box needs to show uniques only.
View 1 Replies
View Related
Aug 8, 2013
i have a list of 5 teams in a named range ("teams") within a worksheet.
On a userform I have 5 combo boxes.
What I would like to have is an easy way to remove a used name in the list for the next combo box.
i.e. someone selects team a in combobox1, combobox2 then has a list of team b,c,d and e. I'll be locking the combo boxes and writing code so the next one will unlock if the previous box is populated.
i also need this to work if someone puts team c in first combobox this then gets removed in combobox2 then in combobox2 they input team e then both these values are removed for combobox3.
only way I can think of doing it is creating a lot of named ranges and using a lot of if then code which I'd like to avoid.
View 2 Replies
View Related
Jan 8, 2008
How do I make a list of selections for user to choose from in my combo box?
View 9 Replies
View Related
Apr 30, 2009
I know how to turn the autocomplete on and off but I donīt have a clue where I configure the data range or the cells to display the list when the combo box is clicked.
I am assuming that this is done in the Edit mode at "linkedCell" and LisfFillRange ... yet I canīt get this to work.
View 2 Replies
View Related
Oct 2, 2008
I have an Excel sheet and I want to populate a list in sheet 2 from data that I will include, little by little, in sheet 1 (I send this information by e-mail, using Excel). With this i want to create like a log to keep a record of what I send every time.
Sheet 1
Document 1
Studio xx
Word count500
Language Spanish
And I just want to have in sheet 2 the following information
Document Wordcount
1 500
I don't need more but I would like to add a new document every time and be able to have a log in which I know the word count that corresponds to every document so that with time I can have as follows in sheet 2:
Document Wordcount
1 500
2 750
3 200
I have been trying to add a button to do this, but it didn't work the 10 times that I tried.
View 4 Replies
View Related
Dec 2, 2009
In column A, I have the following items (chair, table, bed, sofa, wardrobe, shelves, etc) and these itmes apprear more then once. I have named the range as "product".
I want to use the same range to create a list under data menu (Data / Validation / Allow = "List" / Source = "Product") , apparently since the items appear more than once in the range the same gets populated in the list.
View 9 Replies
View Related
Jan 6, 2009
im trying to create a spreadsheet for different makes of cars, here is what i want to do.
in cell one i want a drop down list for various makes of cars, in cell 2 i want another drop down list for the different models from that manufacturer (depending on which on I choose in cell one), in cells 3 and 4 I want different information depending on the make an model of the car. I have got 1 sheel with all this info on it but I dont know how to make it all work nice and neatly with drop down lists.
View 10 Replies
View Related
Dec 10, 2009
I have been using this formula in my report for a while now and i have just updated the table at which it looks at. The table consists of 3 columns - store, store number & division. The value at what vlookup looks for is the store and i have sorted this alphabetically.
But now when i choose the store from a drop down list i get nothing populated in the cell with the formula!!!
=IF(ISERROR(VLOOKUP(I5,$Z2:$AB$419,3)),"",(VLOOKUP(I5,$Z2:$AB$419,3)))
View 7 Replies
View Related
