data validation

  1. J

    Data Validation - To Stop the User Inputting more than one Specified Value in a column

    Hi. I have a question about data validation. Is there a way to remove one of the strings from data validation list if it's already been used in a row above in the specified range? A quick example of what I mean. Lets's say in column A1:A30 each cell has a data validation list of 'A', 'B', 'C'...
  2. R

    Researchable drop down list

    Hi, As my excel version does not have filter, sort, unique functions I have to use other set of formulas to search the drop down list in data validation. Column C Column D running shoes adidas cooking salad eating chocolate cookies sleeping at friend's house baking cookies...
  3. C

    Data Validation - With Exception?

    Hello! Tried finding a response in these threads but no such luck. I don't know if this is possible but basically, I currently have this data validation set: =COUNTIF($E$1:$E$10001,E1)=1 So that no repeating data can be put into a single column. However, I need to make an exception for "n/a" to...
  4. D

    Delete data validation

    Hello, i am wanting to see if there is vba code that can delete data validations from cells. I have a data validation on cell D66 on "Sheet 1". This validation is repeated every 3 columns over so like an offset from column D of 3, Column G, J, M, etc. Is there something VBA to delete these...
  5. H

    Dependent Drop Down Lists

    Hi all, hoping someone can help with this one. I'm currently working on a spreadsheet to track training data, and one thing I'd like to add is a dependent drop down list for the training provider. It would have a drop-down list in Column J to select the "Provider Type" (either external or...
  6. F

    Creating a changing data validation list

    Hi. I need some assistance. Let's say that I have 10 available words in an excel table. In another table, I would type in one of the 10 words. How do I do the formula so the original table shows only the remaining 9 words? Example. TEST1 TEST2 TEST3 etc down to TEST10. I go into another cell...
  7. C

    Create Cluster Chart that Updates Automatically with New Data

    I am working on a sheet where we are tracking a person by the number of issues during the year and the reason. I have included an example spreadsheet. Columns A-C will change depending on what is found during the review, but Column D has three options to choose from. Once a row has been updated...
  8. C

    Create Cluster Chart that Updates Automatically with New Data

    I am working on a sheet where we are tracking a person by the number of issues during the year and the reason. I have included an example spreadsheet. Columns A-C will change depending on what is found during the review, but Column D has three options to choose from. Once a row has been updated...
  9. Akuini

    Macro to create searchable data validation+combobox

    Excel doesn't provide a built-in way to search data validation list. So it could be hard to scroll through the list when the list is long. This searchable data validation+combobox is a way to deal with that problem. It has these behavior: 1. The combobox can appear and hide by certain action e.g...
  10. D

    DATA Validation Multiselect and Prevent Copy Paste in Data Validation

    Have used a Multi Select Data Validation List in excel using the Below code available. Private Sub Worksheet_Change(ByVal Target As Range) Dim Oldvalue As String Dim Newvalue As String Application.EnableEvents = True On Error GoTo Exitsub If Target.Column = 2 Or Target.Column = 26 Or...
  11. Akuini

    3 or More Dependent Data Validation, with VBA, easy to set up

    I want to share a macro to set up multi dependent data validation with vba. Some versions of dependent data validation use formulas to set them up, usually with indirect functions. For 2 or 3 dependent data validation & small data set, it's pretty easy to set it up, but for more than 3, it might...
  12. M

    Adapting VBA Code to Exit Loop on encountered blank cell (Data Validation List)

    Hello Guys, I am using the code below to iterate through a data validation list, however in the data validation list there are a lot of blanks. I wish to stop the loop when a blank row is encountered. The code works perfect, but it keeps looping until infinity. Does anyone have an idea what...
  13. M

    Can I make the data validation dropdown list expand to show more choices?

    I have several data validation dropdown lists [not combo boxes from the developer tab] that have more than 12 items in them. Is it possible to edit the list's format so they display more items in the list when the dropdown is clicked?
  14. I

    Issue with Data Validation List (does not display) after VBA runs

    Hi all ?:) I am seeking some help with a Data Validation dropdown that is not functioning properly after VBA does its thing. An answer to a question I posted recently to resize some rows and clear a cell (and a little bit more) was provided by steve the fish, and his solution works brilliantly...
  15. T

    Allow user to input specific text and number-need VBA code

    hi anyone can help me on below, I want users to enter specific text (AB, DO, SL) and numbers (-10 to 20) in the cell range(A1:B10, A20: B30). Users should be able to enter only allowed data. if not cell should be clear. I don't want to use data validation impact I need VBA codes. please help...
  16. S

    PUT COLOR IN THE CELL

    Hello, I need code for data validation to set color in the cell In the picture I explained Thank you in advance for your reply
  17. A

    Data validation for showing error

    In F5 ,I have a List. if any one select this values "Book1","Book2" and "Book3".. i have to show some error using data validation "=OR((F5<>"Book1"),(F5<>"Book2"),(F5<>"Book3"))" why this code is not working??
  18. S

    Filtering based on a dropdown list in Power Query

    Hello, I am using Power Query to pull multiple data sets into a single workbook. I have a table within that workbook that contains a dropdown. What is selected in that dropdown determines how the data pulled in by Power Query gets filtered. See attached for further explanation. It works...
  19. E

    Data Validation

    I am trying to get some data validation to work based on if a certain value is entered to not allow it and notify user. I see all the options are to compare to “allowed values” but I would like to prompt user and not allow just the letter C to be entered in some ranges of cells. How would one go...
  20. R

    VBA: Macro to delete range runs normally, gives error 1004 if I click on a cell with data validation

    This is my first post here, so sorry if I made any mistakes (this forum has helped me a lot before tho, thanks!). I'm trying to make a macro that will delete everything within a range of cells, but I'm running into a weird issue. There's a couple of checkboxes and a picture that don't get...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top