Programme To Automatically Select A Value From A List Or Range Once A User Has Selected Corresponding Value From A List Within A Combobox
Jan 28, 2007
i'm writing a refrigeration selection user interface, working from values on an excel spreadsheet. how to get the programme to automatically select a value from a list or range once a user has selected corresponding value from a list within a combobox. for example if a user sets the temperature of their refrigerator to -5 celsius i need the programme to automatically select the corresponding value of enthalpy for the air at that temperature.
View 5 Replies
ADVERTISEMENT
Mar 31, 2014
I currently have a macro that takes a user selected name and date and creates a time sheet for the selected name. This works just fine, however i have to select each individual person and run the macro for each person, how to automate that part of the macro, so it will automatically create the said sheet for all person at once, rather than me doing it manually.
[Code] .....
The 'CurrentMonth' variable is user selected from a list, and will remain that way.
View 4 Replies
View Related
Jan 20, 2014
I have a spread sheet for equipment that gets loaned out on a regular basis. Cells B4 - B25 have combo boxes in them, with the options to select "On Loan", "In Stock Room" etc in them. What I would like to do is create something so that as the combo box is changed, i.e. from "In Stock" to "On Loan", a date changes adjacent to each combo box.
For example, combo box in B10 has been changed from "In Stock" to "On Loan". The adjacent cell records the date automatically that the combo box was changed.
Combo box date example.jpg
View 7 Replies
View Related
Mar 10, 2013
How do I allow the user to select from a dropdown list but disallow them from entering value into the textbox?
View 1 Replies
View Related
Apr 7, 2014
I have a workbook that has three worksheets. The ASU Database sheet contains part numbers and descriptions including specific details that are selected from pull down data validation lists that are named on the third worksheet. I want to have a front end on the first worksheet that has similar data validation lists for the user to select from to create a search criteria that will create a worksheet with only the rows that meet this criteria. I am not sure what method to use to accomplish this.
View 2 Replies
View Related
Mar 20, 2014
I have a combo-box in a Multipage control. Now I want to get the combo-box populated with list in 2 columns from 2 different consecutive columns from the same worksheet (Product List). Now, Once the list gets populated, user will be selecting his choice from the list, which is then needs to get copied to another worksheet (Order Placed). Both worksheets exist in the same or one spreadsheet.
I am trying to make it work with the following code. I am able to see 2 columns but with no data getting populated. I am working in MS Excel 2007.
[Code] .....
View 3 Replies
View Related
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
Sep 16, 2009
Hoping someone would be able to help me with this. I have a sheet (example attached) and this sheet has a number of varying description types in the W coloumn (usually approx 10,000 rows). This field is manually input so there could be spelling mistakes and/or non standard descriptions.
What I would like, if possible, is a macro that would look at the D column and if this is 'GENERAL LEDGER', it would then look at the W column.
An input box would come up, and would list the different descriptions it found in column W, and number them. It would only list each different description once.
e.g.
1. Bank charges
2. Bank charge
3. Cash
4. Fund Custodian Fees
5. Fund Manager fee
6. Interest income cash account
7. Interest income cash acc
8. Miscellaneous expenses
9. Miscellaneous income
10. Other income
11. Sec lending comm
12. Sec lending commission income
13. Tax Reclaimable - Dividends
14. Withholding tax dividend
The user would then be able to type in the corresponding numbers, if possible seperated by a space, comma or semicolon and the macro would then run through the sheet and delete the entire row if D was GENERAL LEDGER and W was the selected description.
View 9 Replies
View Related
Mar 22, 2014
I am in need of a Macro that does the following:
In cell B4 I have data validation drop down list which refers to the range of values named Tarifalist. Tarifalist list has the following range of values: 01,1A-1F / DAC / 02 / OM / HM / 5A (Baja) / 5 (Baja) / 03
In cell B5 I have a data validation drop down list with =IF(OR($B$4="03",$B$4="OM",$B$4="HM"),Thirty,ThirtySixty) Where range Thirty has the value 30, and ThirtySixty has values 30 and 60
I would like in addition, a Macro which when either 03, HM, or OM is selected in cell B4, that it automatically sets the value to 30 in cell B5. The purpose is so that the input is foolproof, and no user can accidentally leave the value at 60. As of now, if the value has been left at 60, and 03, HM, or OM is selected in B4, B5 can stay at 60, which is not a valid input and must be manually changed.
View 2 Replies
View Related
Apr 29, 2014
I have two cells and both have a drop down list. I would like Excel to automatically select an item from the second drop-down list based on the manual selection of the first drop-down list. The second cell needs the have the dependent item appear in the second cell not just be available in the drop-down list.
For example, Cell A1 has a drop-down lsit of the names of fruits, vegetables and flowers (apples, bananas, carrots, carnations, corn, daisys, tomatoes, zuchinni). Cell B1 has another drop down with three items (fruits, vegetables & flowers) which needs to be dependent on the first list. Further, I would like cell B1 to automatically select the appropriate item.
For example, if "carrots" is selected in cell A1 then I would like "vegetables" to be selected and automatically appear in cell B1. If "carnations" is selected in cell A1 then I would like "flowers" to appear (not just be available in the drop down).
View 6 Replies
View Related
Apr 8, 2013
I have a spreadsheet where user can search for information inside a search box and the appropriate rows are returned using formulas.
I have a drop down list (Category: Model) in the search box as well as a search field (Category: Program, cell D2). Underneath the search box, search rows are returned with column categories: Program, Model, etc.
What I require is that if a user enters the specific program into the search field D2, then the dropdown list would automatically choose which model that program belongs to based on the returned row.
For example, if I typed "engine" into D2 and pressed enter,
Under the records section (Row 14 and beyond), the following record will pop up:
Program
Model
Indicators
Engine
F-16
3a
Based on the record, F-16 would be chosen from the dropdown list. Is there any way this can be done?
View 6 Replies
View Related
Nov 15, 2008
I am kind of new to Excel programming and would like to know if there is a solution to my problem. What I need is to have a dropdown list (I know how to make this) then select an item from the drop down, then based on the name i select, Excel automatically fill up the rest of the cells.
For example, from the drop down list I select the company name then Excel automatically type the address, phone number, Fax number and the contact name of the company for me in corresponding cells. Is there a way to do this?
View 3 Replies
View Related
Dec 19, 2006
How can I get a combobox to list the values in a range of cells eg.
A1:A5 = 1,2,3,4,5 etc
I've tried...
ComboBox1.List = Range("A1:A5")
But that dont work (it was more of a guess)
View 9 Replies
View Related
Dec 26, 2012
I like to use the combo box (Active X control). where I need to provide the range/List in the properties. While inputing the value in properties it is disappeared.
View 1 Replies
View Related
Feb 4, 2014
I am trying to work up a referral tracker for my wife's employer. I have Named Ranges on sheet 2, a running log on sheet 1. I also have a userform that is being populated from the ranges on sheet 2. I have the project mostly functional, except for a feature I would like to add in. I am interested in adding to the named range that is being accessed if the entry is not in list, via the combobox1 on the userform. Also, if possible, I would like the list to re-sort behind the scenes so the added entry is properly located in A-Z format for next time. After searching the web a bit, I found some code that might work with some tinkering, but currently I am having issues with it. Here is the bit I am trying to use.
[Code] ....
I have been getting 424 Object Errors and a few others as I continue to mess with this. I am also attaching the project if someone may see a better way of getting the task accomplished. The overall scope of this is to log all referral sources so monthly and yearly reports could be made.
Attached File : Copy of Referal Tracker.xlsm
View 3 Replies
View Related
Jan 1, 2010
I have a combobox whose list is filled with different ranges, on different sheets, selectable using option buttons. The code is shown below:
Private Sub OptionButton1_Click()
Dim ray
Dim Last
ray = Sheets("Trades").Range("B2:B500")
If OptionButton1 = True Then
With ComboBox1
.List = ray
.ListIndex = 0
End With
End If
End Sub
View 9 Replies
View Related
Feb 25, 2008
i have a list of surnames in column A in a spreadsheet i want to use this for the source of the combo box also i want this list to be unique and if the surname is not present i want to be able to put the name in the combo box and add it to the sheet
View 2 Replies
View Related
Jun 15, 2007
I'm trying to use data validation to restrict the user to only selecting values in a list which I create. Right now, the list is a named range. I'd like to get rid of the range and just use a named list. I create a name using the following as my list.
Insert > Name > Create
Name: Fruit
Refers to:
banana,apple,orange
When I try to use the name Fruit in my data validation, I get the message "The List Source must be a delimited list, or a reference to single row or column." I thought my name "fruit" was a delimited list.
View 4 Replies
View Related
Jul 4, 2009
i had a user form with a Combo box,list box,text box and a command button. I need the code that works upon selecting:
1)An Item from the combo box should display the list in the list box.
eg: If Country is selected from the combobox then the list box should contain all the names of the countries from the country Column
2)An item should be added to the list in the worksheet when an item is entered in the textbox.
Like wise, when an item is selected from the combobox from "Delete Items List" all the items relating to the item selected from the combobox should be displayed in the list box and a choice to delete the items relating to the combobox item should be provided.
View 4 Replies
View Related
Jan 11, 2008
I want to force a user to select a value from a Combobox that I set up in a newly created worksheet from inside a macro - while the macro is still running. I have the code to create a new worksheet, size it accordingly, add a Combobox control, assign a range of values for the drop-down list, but do not know how to suspend the macro and force the user to make a selection from this Combobox before continuing. Not even sure if this can be done.
View 4 Replies
View Related
Jan 12, 2014
how I can list 3 different values to a list of list of 3 in a combo box, is.
combo box
select high = 35
select middle 30
select low = 25
I have the names in the box I just need it to add a value (which I have listed 1 in each separate cells) to each selection
View 9 Replies
View Related
Nov 5, 2008
Need Help in resolving the following issue:
Update a list using a Combo Box works fine when the list is on the same worksheet but when the list is on a different Worksheet it does not work.
Is this achievable? I guess so! but was wondering how to do it.
e.g: if my range defined name called let us say "SP" with a range AD1:AD60 in Sheet1 when I use a combo box the Listfillrange will contain: SP
When inserting a new entry using the combobox it works fine but when the same defined name range points to a different Worksheet example: Sheet2 then the update does not work although the ListFillRange contains the same Range name: SP.
View 14 Replies
View Related
Mar 21, 2009
I am carrying out some sensitivity testing on a model, and would like to greatly increase the speed of the process by being able to call in from a user defined cell a named range, which is then pasted to the right of the cell.
The attached file steps through the process I have in mind.
View 9 Replies
View Related
Jun 20, 2008
I can't seem to find a way to make a data validation list automatically show the first item in the list rather than showing blank.
View 10 Replies
View Related
Feb 9, 2010
The User has made multiple selections with the mouse. The spreadsheet is filtered. The user will usually make different multiple selections on the following columns: A and X through to AR (inclusive).
I just need some code to capture these various multiple selected ranges so that I can copy the selected range as shown below:
View 3 Replies
View Related
Feb 8, 2013
I'm currently working with 3 dropdown lists depending on each other using data validation and =indirect(). I arranged them like in a top-down approach where you have a mother-list and child-lists (categories-->subCategories-->subCategoryCriteria). The user should easily chose first a category then a subCategory etc... This part works perfectly
My question is: when a user chose in the dropdown list e.g. a category, a subCategory and a subCategoryCriteria and he now maually deletes the value in the highest level, which is the Category (mother-list), all sub level values like subCategory and subCategoryCriteria will stay. It shouldn't be that way, because it's not logical. If you turn a tree upside-down (top-down approach) and cut one of the higher positioned trunks, all lower positioned trunks will fall off as well, right? So, my question is: can I use a conditional formatting or a formula to delete or fade out the value in the lower lists when the higher list value is being deleted?
I tried to use If-formula in combination with indirect in data validation, like =IF(A1="";("");INDIRECT(B1))...just and example.
The value doesnt need to be deleted, it could also be automatically face out like white on white or something. It's just confusing for the user if he deletes the highest choice and the lower choices still stay.
View 8 Replies
View Related
Dec 16, 2009
I wrote a macro which creates desired output based on one default variables. But I want to change it to take user selected assumptions and perform the macro for each user selected variables.
I am confused with user forms and controls and what to use.
Can anyone give the code to how to add a list box to a userform and then add items to the listbox, and run macro based on thegiven input in the list box?
View 14 Replies
View Related
Apr 8, 2008
I wanted to create a userform with multipage. On the first page I want to use a ComboBox that would allow the user to select the customer. The customer name is on the sheet that I named "Customer" which also contains the street address/city/state/zip. What I would like is, once a customer is selected, I want a textbox that will be populated with the correct address taken from the sheet named "customer".
On the second page I'd like to use it for Product Info. I want to have a ComboBox, Text Box, a Command Buttons. The ComboBox is to select the "Model#" from the sheet named Product Info" and the TextBox is for the user to write their comments. One of the Command Button is to be view a sheet named "Quote" and the other is to send the "Quote" through email.
View 2 Replies
View Related
Oct 27, 2009
I am trying to learn the concepts, then apply them to a set of actual worksheets. I am trying to use named ranges from one worksheet in another worksheet. The named ranges need to expand. Although I can get the add data to a dummy worksheet to work within the same worksheet and I can even get a named range to work in the foreign sheet.
My problem is, when I can end up adding the additional data to the named range, it will only add one name. I have a number of named ranges that are referenced on various worksheets. The idea is, certain named ranges should be able to expand so I donft have to type them all in. (There could be hundreds of manufacturers or models.) I would also like them to be able to sort themselves after additional names are added to the named ranges. I would also like them to auto populate as well. I am using Excel 2003 SP3 (11.8307.8221). I have enclosed the file. Drop down lists (named ranges) are on the worksheet called DROP DOWN LISTS (LOCKED) **ITfS NOT CURRENTLY LOCKED**.
The data validation issues are on the worksheet called Rev7.0 Wood (Basic Sheet.) There are other instances to use these, but I hope to learn to do them myself on the other worksheets. Of particular interest is Column f.................
View 3 Replies
View Related
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
