VB To Activate List Drop Down Boxes When Data Is Entered In A Cell

May 20, 2009

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.

View 14 Replies


ADVERTISEMENT

Create Drop Down Boxes Based On List

Jan 29, 2008

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..................

View 2 Replies View Related

Creating User Form With Drop Down List Boxes

Sep 29, 2009

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 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

Drop Down Boxes (getting Data From Other Sheet)

Nov 15, 2008

I 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 Related

Adding Drop Boxes To Cells With Data

Nov 27, 2009

I 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?

View 2 Replies View Related

Create Drop List That Populates Cell With Some Other Data?

Feb 4, 2014

I am trying to create a drop down list so that when the user choose Option A, Outcome A populates the cell.

So for example, I am looking to show a list of all Grades within the company, when the user selects a grade, the salary is populated into the cell.

View 7 Replies View Related

Drop Down List To Fill Adjoining Cell With Corresponding Data

Dec 19, 2007

I have a list of 688 codes in a column (lets say column A). e,g 23, AB, FX, NV, D8. Each code corresponds to a text In the next column (lets say column B) for example AA is the code for "Transmission". Using a clean spreadsheet and using a drop down list, I would like the cell to the right of the selected dropdown code, to automatically fill in the text of what the code corresponds to.

View 5 Replies View Related

List Box Of Ranges, Pick One To Activate That Cell

Mar 30, 2007

How can I add multiple cells (ranges) to a listbox, and when the user clicks one, it will activate that cell in excell. I thought about have the list box for the text, and a corresponding array that holds the actual range or address, but I cant get it working.

Long version:
I have a search feature that, when you type a name, it searches through a column and finds the name. Now if there are multiple matches to your string, I want it to add the full name to a listbox, and have the user pick one from the list to activate.

So basically, if I search for the name "john" but theres multiple people with that name ("john doe", "john smith", & "john mazz"), it would add the three to a list box, I would pick one from the list, and it would activate that cell.

I have everything done except that last part. I have it adding multiple matches to the list box, but I cant figure out an easy way to activate the correct cell when double clicking the item in the list. I could have it search again for the selected full name, but there is likely to be a case where one person is entered twice.

View 8 Replies View Related

Drop Down List Which Displays A Different Set Of Values Depending Upon The Value Selected By A Previous Drop Down List

Oct 26, 2009

I need to have a drop down list which displays a different set of values depending upon the value selected by a previous drop down list. ie. (drop down box 1)= x, y, z. (drop down box 2)= either x1, x2, x3, or y1, y2, y3, or z1, z2, z3. I can produce a single drop down box thats not a problem but linking several drop down boxes is beyond me .

View 4 Replies View Related

Data Input Form Not Validate List Boxes

Dec 8, 2009

I am creating a spreadsheet where the user enters food they have eaten that day. The way this is done at the moment is with validated list boxes, one depending on the other using the indirect function. I want to be able to make this into a user input form. Is there a way of adding these validations from the spreadsheet, to an input form.
I want the input form to have an input for the day, food group, food item, and quantity of the food. The food item needs to depend on the food group.

View 9 Replies View Related

Sorting With Drop Boxes

Oct 22, 2008

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 Related

Linking Drop Down Boxes

May 13, 2009

I 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.

View 14 Replies View Related

Drop Down Boxes And Hyperlinks

Feb 14, 2007

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 Related

Drop Down Boxes (linked)

Mar 1, 2007

I 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

View 9 Replies View Related

Drop-Down Boxes In Cells

Aug 11, 2006

I need to place a dropdown box with three options in all cells in lets say column C.

View 2 Replies View Related

List Boxes, Combo Boxes???

Jul 26, 2006

I am developing a spreadsheet with numerous information on our different suppliers offices in the country for each of our outlets. I am tryin to define a way to do the following:

If a colleague selects a company another list will appear with the region and when the region is selected a list of the offices will appear.

View 3 Replies View Related

Multi-Layer Drop Down Boxes

May 14, 2009

I 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.

View 8 Replies View Related

How Do I Link Mulitple Drop Down Boxes Together

Feb 20, 2006

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?

View 14 Replies View Related

Multi Select Drop Down Boxes

Apr 21, 2009

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

View 9 Replies View Related

Formula: Make Drop Down Boxes

Aug 3, 2009

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.

View 9 Replies View Related

Creating Drop Down Boxes For Job Sheets

May 9, 2006

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 Related

Drop-Down List: Generate A List Based On The Value Of A Cell

Jan 7, 2009

I am trying to generate a list based on the value of a cell. That list will then be used as the range for a drop-down list. Example: Cell A1 returns a value of 15
A drop-down list displays the values 1 through 15. Cell A1 changes to 20
Drop-down list displays the values 1 through 20. I assume I'll need a two-step macro to accomplish this but I can't figure out the logic to populate the drop-down.

View 3 Replies View Related

Jump To First Entered Character In Data Validation List

Jan 5, 2014

This is my data validation formula:

=INDIRECT(VLOOKUP(H104,cat_opt_Table,3,FALSE))

Some of the lists will have up to 200 lines in them and I'd like to find a way to simply to jump to the first letter entered in the data validation cell.

Does the list need to be alphabetized?

Could it be something that is entered into the data validation box? This spreadsheet has data validation in 35 columns.

View 2 Replies View Related

Using Drop Down Boxes And Not Being Able To Select Previous Values

Dec 10, 2009

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.

View 9 Replies View Related

Drop-down Boxes Make File Size Too Large

Aug 31, 2009

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?

View 3 Replies View Related

Macros Untick Boxes As Well Reset Drop Down Menus

Jan 17, 2009

I am wondering how to create a macro that will untick boxes as well reset drop down menus.

View 9 Replies View Related

Determine If A Country On List Has Been Entered In A Cell?

Apr 18, 2013

I have a Userform that allows the user to input a country from a combobox which after clicking a button writes that data into Cell AH11 in the excel spreadsheet, what I need is for Cell AI11 to read what has been entered into Cell AH11, look up whether or not that country is on a list I have and enter a yes or a no if it is or it isn't on that list.

View 3 Replies View Related

Username Entered In Cell When Validation List Is Used?

Apr 25, 2014

Is there a way to have a formula or a VBA code associated to the choice of any value in a Validation list.

For example is there a way to have lets say in A1 a validation list and to have B2 returning the username of the person of who will select a value in A1?

View 9 Replies View Related

Cell In Excel To Determine If Country On List Has Been Entered In Cell?

Apr 18, 2013

I have a Userform that allows the user to input a country from a combobox which after clicking a button writes that data into Cell AH11 in the excel spreadsheet, what I need is for Cell AI11 to read what has been entered into Cell AH11, look up whether or not that country is on a list I have and enter a yes or a no if it is or it isn't on that list.

View 2 Replies View Related







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