dropdown box

  1. A

    Check Box in Drop down list

    Hi all, I'm in need of a Check Box in Drop down list for multiple selection. The code which i had is given below. The disadvantages of the given code was duplication and unable to edit the selection. Private Sub Worksheet_Change(ByVal Target As Range) Dim Oldvalue As String Dim Newvalue As...
  2. C

    How to search on numbers via dropdown box to return results in subform

    I've created the query on InvoiceID which is a large number. I have already created the search drop down box showing numbers in order. However when I select the number the Subform blanks out (there is data) rather than showing the results of the InvoiceId. I have used this code on other...
  3. C

    split worksheets based on dropdown

    Good morning, I have a report with 500 separate account results - these are currently set up as a self serve via a dropdown. What I want to do is create 500 separate split worksheets based on the dropdown choice. However I want each worksheet to display all the results /charts etc which are set...
  4. M

    How to reference a data validation answer in a cell in another sheet

    Hi, I am recieving a #VALUE ! error when trying to copy the result of a data validation drop down in another sheet and dont know why. e.g. In sheet 1 I have a a drop down box in a cell (A1) that has recent dates in. On sheet 2 I want the chosen date to show in a cell. I have put the formula...
  5. S

    Message to user of which to select in 3 different drop downs.

    Hello, I'm currently working on trying to have a warning box that indicated when the drop downs have not been selected, but I'm coming back with too many formulas for this one box. Currently I have: =IF(AND(B4="Choose Current Grade", B6="Choose Proposed Grade", B8="Select Geographic...
  6. A

    Dropdown list for the Item listed in the PivotTable Field List ?

    Hello everyone, I am almost done with a large dashboard for my company, and I feel a little lost on this final touch I want to add to it. I do not know how to attach a pic, but i will try to explain in a way that makes sense. In my Pivot table worksheet, i can get a slicer and be able to...
  7. D

    Seeking Cool Drop Down Box Design

    To Excel Giants Everywhere - Please help, I am familiar with the general options for drop down lists... i.e. format the cell to reference a list and then check one. Is there another solution where a user can check multiple options and then those options are stored in one cell? If so, is...
  8. M

    Drop down to generate list from table

    Hi I am looking to generate a list from a drop-down menu. On sheet 1 there is a table which lists “keywords” in column A and “policies” in row 1. Within the table “x” is marked where a keyword is found in a policy.</SPAN> On sheet 2 I have a drop down list with all the keywords and what I...
  9. B

    Code to find value based on dropdown selection

    Hope someone can help... I have a dropdown list of employee names to filter a matrix-style spreadsheet. On selection, all columns except the selected are hidden. My problem is that every time I add a new employee, I have to modify the code to match the name to a specific column. I need code...
  10. P

    Drop down boxes

    Hi All I have a list of industries which I would like to have as a drop down box, to restrict only the industries included in the list. I'm not sure how to do this. Any help please. Many thanks :confused:
  11. J

    Create table based off drop down box selection

    Hey All, Im trying to create a table based off values in another reference worksheet which will be generated from a value selected from a drop down box. The values in this newly generated table is then to have a dropdown box next to them in which W or L can be selected. the link below...
  12. W

    Using dropdown box to change data in spreadsheet

    I have a dropdown box which I want to use to populate data into about 10 different cells on the top of a spreadsheet. There is a lot more data on the spreadsheet that I do not want to change with the dropdown box, this data will also feed into other sheets in the workbook.
  13. B

    Checklist/Dropdown - Screenshot included!!

    Hi, I am researching companies and tracking my research using an excel spreadsheet. I've created a rubric rating a company 1-5 with 5 being the highest rated/i.e. best potential sale. Each of the following items is rewarded with one point for each of the following. 1. High need of paper...
  14. D

    Using two data validation lists to select element in array

    I am trying to use two seperate dropdown lists to select a specific value in a table of set values. The first drop down will select the row and the second will select one of two columns. I have the data validation lists ready to go but it looks like the main hangup I'm getting is having the...
  15. L

    How to automate data entry in a cell using Drop down menus ?

    Hello, Is it possible that selecting an item from drop down should enter certain text in a cell ? For example in cell "L7" there is a drop down with two items 1) pay due 2) Bill Selecting (pay due) should enter following text "Payments are due from the dealer, requires special attention."...
  16. S

    Autofill Drop Down Box

    Hi This is my first post. I'm wanting to know if there is a way to auto fill a drop down box. For example I have a drop down box in Cell A1 which has an input range of $E$1:$E$4 and a cell link to Cell A1. I now want to have another drop down box in Cell A2 with the same input range and but...
  17. F

    IF functions and drop down boxes

    Good morning Mr Excel, I am trying to create a formula that allows me to have different options populate a cell depending on the content of another cell. I think i have done this before but cant remember the finer points, =IF($C$7="Select Axle...
  18. A

    Combo Box Selection Populate Corresponding Cell

    Hello, I am attempting to use an ACTIVE X combo box. to deliver the desired function. What i would like to do, is make a selection from the drop down combo box, and depending on what i select, have it populate other fields. PLEASE HELP!!!
  19. andrewb90

    Issue with VBA

    Hello, I have this code: Code: Sub comments1() With ActiveSheet With .Rows("180:186") .Hidden = Not .Hidden End With With .DropDowns("Tag1_1") .Visible = Not .Visible End With With .DropDowns("Tag2_1") .Visible = Not .Visible End With End WithEnd...
  20. P

    Remove Blanks from ComboBox.

    Hello there, I hope you are all well. I have a project file that contains a table with employee names. I have a formula on the 1st column of the table (reference) that will be visible if the "Available?" column is set to "Yes". I want to send an email to one of the employees that shows the...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    • Replies: 49
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    • Replies: 40
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    • Replies: 35
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    • Replies: 35
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    • Replies: 30
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    • Replies: 25
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top