I have 2 drop down lists made, but I want to have one linked to the other
one.
For example the first list has types of wood in it.
Bamboo
Maple
Oak
The 2nd one has pricing in it.
1.25
2.50
3.50
If I click on Bamboo - I want the 2nd list to auto generate 3.50. Can that
be done?
How can I link two text boxes in excel so the text can flow from one to another?
View 2 Replies View RelatedI am looking to connect 2 form control boxes and have the second box run 2 different types of macros. The first box will have only 2 options - select by week and select by month.
The second box should show the list of weeks or months based on the selection in the first box. Then for the second box, if weeks is shown, a week macro should be run whenever a week date is selected. Similarly for the list of months, a month macro should be run whenever a month is selected.
I have been trying to do this for more than a week (after posting on this board) without success. I apologize if this seems like a duplicate post.
I'm trying to link two combo boxes via a user form. I'm trying to select a city in one combobox which in turn would provide a listing of zip codes for that particular city in the next combobox.
View 6 Replies View RelatedI have a spreadsheet setup which includes a number of checkboxes set up using the forms toolbar.
I would like to link each of these checkboxes (in sheet1) to a cell reference in sheet2. I'm trying to write a macro that will do this for me to save me right clicking, choosing format control etc for each checkbox.
I found the code on this page: http://www.mrexcel.com/archive2/51300/59643.htm
which appears to be similar to what I am trying to achieve. In this case it creates the checkboxes in cells B3:B20 and links them to C3:C20.
I have already created all the checkboxes, and wish to use a macro to link them (for example) to C3:C20 in sheet2.
Adding new items to the list, and then sorting them, I've found that the drop down boxes which I was oh-so-happy to utilize... don't move with their relative rows when the item name or department is sorted. IE. The option to select Supplier 3 for Thing 4, stays where it is if you sort by department, giving incorrect options. how to sort this while moving them, or on an alternative menu box system which would sort?
View 2 Replies View RelatedI am trying to link 'Combo boxes' in Excel 2007 (not using code as the guy in the other thread is). Ie In the first drop down box you choose the type of cement, then in the second drop down box, different mixes of cement can be chosen DEPENDING on your choice of cement in the first.
I'm not sure if I will need to use VBA for this or not, but what I want to is enable a Hyperlink if the user enters "Yes" from a dropdown box in a respective cell. I will have "Yes" or "No" as choices, but I only want the Hyperlink to become active if "YES" is chosen.
View 9 Replies View RelatedI would like to have a list of car colours and when clicked a drop down box appears and when the colour is clicked the price appears in another cell - drop down box linked to a price for a particular colour
eg
Colour
Cololur Price
Red £200
Blue £200
Green £250
Black £300
Silver £350
I need to place a dropdown box with three options in all cells in lets say column C.
View 2 Replies View RelatedI have two sheets open being a front sheet and one with data, i would like to create a drop down box of some kind on the front sheet with the data listed in the box from the data sheet.
View 7 Replies View RelatedI have a file that needs 3 drop down boxes.
Box 1 = Room Style
Box 2 = Unit Number (based on Room Style)
Box 3 = Building (based on Unit Number)
I know how to get Box 1 and 2 with data validation, but I don't know how to get Box 3. Right now, my data list has Box 1 data in Row 1, and Box 2 data in the following rows, in the appropriate column.
File attached.
I don't have the Building info in there yet because I didn't know where/how to put it in. But, if you picked Manchester, 131, Box 3 needs to be B1N.
i want to have an input box where i can select say 5 cities and have a chart of the weather in all those cities.
http://www.4shared.com/file/10050153...mpweather.html
is the excel file
Column A - I want to make drop down boxes #1-30 - which would represent quantity
Column B- That will be 30 rows of dollar amounts
Column C - To be able to calculate the quantity x dollar amount
I'm able to create the drop down boxes with the numbers, but say I choose the number 5 by the dollar amount 200.00 It won't calculate 5 x 200.00....
I've been trying the formula you would use to find an average, and i've tried the if statments, but my drop down box isn't being recognized.
I am trying to create drop down boxes in a spreadsheet so I can create job sheets from them, I have a small business building cubby houses and I want to create a job sheet from a spread sheet that will have customer name - job number and so on thats the easy bit but I need to have a few drop down boxes so I can just click on what type of cubby they want from a list and what colour roof and what side door will be on and so on instead of having to type all this in for every job.
View 6 Replies View RelatedI need to add drop boxes (from data already listed on another worksheet) to every cell in a single column. Drag down, easy! My problem is that I already have the required list (names in this case) pasted into the column from another sheet.
Is this possible?
I am wanting to configure approx 100 drop down boxes to all point to the same range of data, approx 40 names, but once the name has been selected, none of the other drop down boxes will be able to select that name.
eg.
range:
Dave
Mike
John
Steve
select Dave in drop down box in cell B5. Next cell, B7, I want a drop down box without Dave in it.
If i then change my mind, and select Steve in cell B5, it will automatically adjust cell B7 to allow Dave as he is now no longer selected in cell B5.
My problem is i need to create a drop down box in excell, now i have a list of names,
Name 1
Name 2
Name 3
Name 4..........
I need all thos enames in a drop down list but i think i keep doing things wrong, I am doing it like this,
All names are in cells A23-A33, i have highlighted them and named them (Names) using the name box in the top left corner, i have then gone to Data, Validation, List, Then i have sourced it to "Names" and clicked ok, this is where my problem is. It Makes all the boxes for Name 1 - Name 10 Drop Down Boxes... And when i click on any of them it gives me a list of all the names, when i click on one of the Names that name appears in the drop down box but the original Name dissapears from the box completely!
Name 1
Name 2
Name 3
Name 4
Name 5..................
I'm using Excel 2007. I have a cell with a dropdown box that has the values 1 thru 10. When I save the file (as an Excel 97-2003 compatible .xls file), it's 17kb which is normal. I want multiple dropdown boxes going down the same column, so that every time the user goes to the next row, another dropdown box will be displayed. I copied the cell with the dropdown box, selected the entire column, and pasted the dropdown box.
This time when I save the document, it's over 2MB in file size. I've seen other spreadsheets with several columns of dropdown boxes spanning thousands of rows and they stay under 30kb. I don't know what they did differently to keep their file size small. Why is my file size so large and how do I fix this? Do I need to use a 'paste special' function?
this is my first attemp at doing a "userform". I am looking for some help in creating a user form that enables users to choose items from drop down boxes, which shows next level drop down list items, then down to final drop down list with information based on first two choices. I've attached the sample file for reference.
View 3 Replies View RelatedI am wondering how to create a macro that will untick boxes as well reset drop down menus.
I have a Validation drop down box (column B) and a defined range drop down box (column E linked to the Totals tab with A2-A31 defined as Products) that I need to activate everytime data is added to a new line in column 'A' and cells in column 'B' or 'E' are selected. Additionally, they need to activate if the cells in column 'B' or 'E' are selected for any of the old data so changes can be made. This will help reduce the overall file size and calculation time for a year's worth of data.
There is already some code on the worksheet that looks like it can be adapted if someone knows how to code in the drop down boxes.
I am somewhat of a novice with Pivot Tables. One problem I am having that no one seems able to help me out with is that when I update and refresh my pivot table, it seems like it has a muscle memory with the drop down choice boxes.
For example:
Lets say I have three customers that I have labeled 01 Target, 02 Walmart and 03 Bed Bath and Beyond. If I want to change 01 Target to 02 Target and 02 Walmart to 01 Walmart, it works in the pivot table and shows the proper data but if I try to choose the customer from a drop down box, it remembers the customers as labeled as they were before I made the changes AND the current look.
I will see: 01 Target, 02 Target, 01 Walmart and 02 Walmart in the drop down box but the data will only show up in the pivot table associated with the proper customers as they are labeled in the data source.
ive done some data validation and created a drop down list but what im trying to do is
once i have selected what i want from the drop down list i would like a picture to appear next to it automatically
ie
if i select kettle it will show a pic of a kettle
I made drop down form controls that specify yes/no as to whether I have the documents I need for a project- when I selected yes the same row will turn grey. Each form control is set to move/resize with its cell, so it stays on top of the cell. I have the drop down form set to cell link to the cell below it in the form control settings. So it would be over cell A1 and the value of 0/1/2/ would be entered into A1. However whenever I copy the cell/row, the new form control drop down does not update its cell link by relative positioning, the new cell link is also A1 – thus both drop downs are linked together. I do NOT put absolute referencing $A$1 so I don’t know why the new copied forms don’t update and point to B1?
Why doesn’t my drop down menu update its cell link position when I copy and paste the cell it is attached to? Can form controls update their cell links via relative references (that is without the $$)?
I have 6 worksheets that are identical cosmetically. Each has the same drop down box list with the same name (dropdown1), however the cell link on each sheet is different. (ie. sheet1 dropdown1 cell link refers to a sheet ' lookup' cell $K$1, sheet2 dropdown1 cell link refers to sheet 'lookup' cell $K$2, etc.) I have the same command button in each sheet that performs the same task so I wanted to keep one module for all 6. Problem is I set a variable to the cell link in the code, and this has to be changed.
DropDownValue = Sheets("Lookup").Range("K1").Value
Is there any way I can set this variable using a property of the drop down list?
DropDownValue = dropdown1.celllink
I don't want to create 5 more duplicate modules just to change this one bit of code (I only use it this time in the code!). If there is no way to get the cell link value of the drop down, could I possibly put a worksheet change event on the lookup sheet to populate a certain static cell with the value of the last cell change?
I'm trying to categorise a load of expenses against their appropriate budget and sub-budgets. I've got all the budget subcategories in separate dynamic named lists each headed by the main budget name. I want to be able to select the main budget name e.g. marketing or sales etc and then see, in the next column over, only the appropriate subcategories to select from e.g pick the appropriate dynamic list (I've used dynamic lists so I have some flexibility to add new categories at a leter date).
View 2 Replies View RelatedI am trying to using multiple if staements regarding one cell. What I am trying to achieve is:
if b2=0, then null, however if b2=1, then arable, however if b2=2, then manged grassland, however if b2=3, then forestry/woodland, however if b2=4, then semi-natural vegetation, however if b2=5, then urban, however if b2=6, then water
I have these 2, but they don't work - what am i doing wrong?
=IF(B2=0,null, IF(B2=1, Arable, IF(B2=2, Managed_Grassland, IF(B2=3, Forestry/Woodland, IF(B2=4, Semi-natural_Vegetation, IF(B2=5, Urban, IF(B2=6, Water, NO_LAND_USE)))))))
=IF(B2=0,IF(B2=1,IF(B2=2,IF(B2=3, IF(B2=4,IF(B2=5, IF(B2=6, Water, null), Urban),Semi-natural_Vegetation), Forestry/Woodland), Maneged_grassland), Arable), null)
How do you set the code so that, if a condition is met, then several cells are filled with values?
So far, my code is
HTML If Cells(i, 2) < Cells(i, 4) Then
Cells(i, 5) = "A"
Cells(i, 6) = Cells(i, 2)
End If
i want to look up a name that occurs several times in one column of a
spreadsheet and return corresponding values from each row the name occurs on.
Vlookup returns only one value. How can I get multiple values?