drop-down

  1. M

    Macro To Populate Cells

    Hi I have a workbook with 2 worksheets - (A & B) Worksheet B holds a list of teams, I.e. Team 1 in Column A, Team 2 in Column B etc.... On worksheet A, in Cell A1, I have a drop-down with all the relevant teams on worksheet B What I would like to do, is: If for example, Team 1 is chosen from...
  2. E

    Stuck in a combobox event

    Hi I have a CB1 combobox, the problem is: I want to trigger an event ONLY when I click on a value in the drop-down list. There's a FilterTheComboBox sub that filter as I type in the dropdown list. For example, suppose a dropdown list with: "House", "House A", "House B". 1) Using MouseClick...
  3. J

    Prevent conditional formatting moving if user copy/pastes?

    Hi, I have a sheet set up which changes colours of cells based on Dropdown box value Problem is I have 5 drop-down (1 for each day) and people copy paste from Monday to the other days and it breaks the formatting Example A2: user input B2: user input C2: drop-down box ( option sets...
  4. M

    Data validation comments...appearance

    I'm trying to get the comments from the cells that are on another sheet to appear when my users hover over cell where drop-down list is. Please help, Mike in Cali...
  5. S

    Macro (maybe a loop?) That cycles through every option and pastes result onto new sheet

    Hi Everyone! :) I am trying to create a macro for the below steps but I am new to using this tool and facing issues. Could anyone please help me with this? In cell D2 of Sheet1, I have a drop-down list with 3 items. In cell D3, users can input a number (0-55). In cell D4, users can input a...
  6. J

    Formula Using Drop Down Menu

    I'm trying to create a reforecast model that will automatically update values based on the month that appears in a drop-down menu. I have the drop down menu created -- it's just a matter of getting the formula to pull the correct value. SHEET 1 has the months in column C through N (row 3)...
  7. J

    #value error - I thought I understood the IF statement

    When I have the first line of code, the if statement works. When I add the second line, I get a #value error for all selections from the drop-down box. I do not understand what id wrong with the logic? =IF(OR(A3="GE",A3="GEL",A3="SR",A3="SRL",A3="VIL",A3="VP"),IF(AND(B15>0,B15<200),"CF <...
  8. O

    Create comparison table by selecting data from another worksheet

    Hi All, I would like to use Excel to create a comparison table, the idea is that in first sheet, it provided three drop-down list for user to select, the list items is related to another sheet database. Once the user selects one item, its related information contained in the database will show...
  9. P

    Fill cells according to drop-down list

    I would like to fill cells A3 to F3 with light red or green according to drop-down list selection. In the drop-down list F3 there are two options´Buy´ or ´Sell´, if ´Buy´ is selected then cells A3 To F3 will have a green fill, if ´Sell´ is selected then cells A3 to F3 will have with light red fill.
  10. P

    ClearContent for drop-down fields

    Hi, I havecreated a template for my staff to use. I've written code that generates aunique sequence number and saves the file but I am having trouble when it comesto removing any information that may have been pre-existing on the form. I amcurrently using the ClearContents command but I've found...
  11. M

    Conditional Formatting Based on Selected Drop-Down

    I'm looking to enhance my conditional formatting to highlight the cell in column C if the content is not an option from the drop-down fields specific to another cell. My spreadsheet has two columns with different drop-down fields. Column B is the subject and column C is the Type, below is an...
  12. B

    List Data If, Then Statements

    Looking for assistance on the following: I have a basic drop-down list which has a choice of Yes or No. I am trying to write a formula that will check which was selected in the drop-down. If the choice was Yes, then x, else y Is this possible? Thank you!! -BB
  13. J

    VBA to create a drop-down list of say, red, green, blue.

    Here's the details: Let's say I have a drop down list in 1400 rows of column Q. The drop-down list is populated by a named range, COLORS. I was a drop-down list in every cell of the 1400 rows of Col Q. Easy enough. Here's the rub: The first item in the drop-down list is RED. If a user selects...
  14. A

    Changing formula based on player's name

    I recently created a small database full of NFL players that is split into different positions (linebackers, cornerbacks, quarterbacks, etc.). I also have a spreadsheet in it dedicated to finding a best comparable player at their specific position. In this sheet, there is a list of players at...
  15. J

    How to select a certain item in a drop-down list using VBA?

    If I select a certain item in a drop-down list, is there a way to populate a certain item in another cell that has a drop-down list?For instance, let's say I have a drop down list in A1 which lists RED, GREEN, BLUE. If I select RED in A1, if B1 has a drop-down list which lists 1,2,3, can I have...
  16. J

    If "red" from a drop-down list in A1, then "certain text" in B1, else a drop-down list in B1. How?

    If "red" from a drop-down list in A1, then "certain text" in B1, else a drop-down list in B1. How can I do this with VBA? I want to create a drop-down list in, say A1, which returns RED, GREEN, or BLUE. If a user selects, say RED in the drop-down list in A1, then I want another text string to...
  17. N

    Multiple Selection on a dependent / cascading drop down list

    Hello all, I am trying to put together a sign-off sheet of responsibilities within my organization. To do so, I've created two cascading drop-down lists via Data Validation: Independent Drop-Down: Department within the organization Dependent Drop-Down: Position in the corresponding department...
  18. J

    how to hide/unhide columns with a drop down box

    i would like to add a drop-down box (similar to the built in filter drop-down) capable of selecting a value or multiple values in cell U2, then if V2:DE2 = the selected value(s), then hide/unhide that column(s) based on what is selected or not in the drop-down. can this be done?
  19. L

    Lock/Unlock Cells in Excel Depending on Selection in Another Cell

    Hi, I've been attempting to lock/unlock a range of cells within a spreadsheet depending on the value selected in another cell. I have tried many different suggestions, and have made sure that the sheet is unprotected, but am coming a bit unstuck. Any help would be much appreciated. The closest...
  20. B

    Cell Format

    Hey all, I hope you're all well? I have a quick question that you'll find very easy I'm sure. I have a VLOOKUP with a MATCH formula that is grabbing data from a separate sheet based on a drop-down list. Now the issue I'm facing is the data it's coming back which is both a NUMBER or a...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    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
    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
    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
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    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