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

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

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

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?

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

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

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

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

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

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

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

Hi, I'm making a sheet to easily click together invoices/offers. Therefor i've got a data-sheet which has all products on it (per row), with also colums for each 'color' of this product, and the prices of these combinations. Description Yellow Blue Red Table $ 10,00 $ 15,00 $ 20,00...

I have a data validation set in 3 columns so that the answers will remain consistent, and I don’t want this to change. I want cell D to be required if cell B has an answer selected (which will always be “Yes” because of my data validation restriction). But I don’t want cell D to be required if...

I have a workbook with several sheets. I have a power query that consolidates the values from those disparate sheets into one consolidated view. On each of those sheets is a column "Pass / Fail", and the values of that cell are derived from a dropdown data validation list. When the query runs...

Hi all, I have to enter data validation rule in a cell (i.e. Cell A1) that it allows value 0 (Zero) or number value greater then in cell B1. Data must be in decimal points. The whole idea is i want cell A1 value not less then cell B1. But it can be zero (Cell A1= 0 or greater then B1) help...

I've been tinkering for a while, but just can't seem to get this to work as desired. I have multiple tables in a workbook: TblFuel TblVehicles TblPlant_Machinery TblMaterials TblLabour I'm creating a quote page where the initial selection is for one of these item types(Fuel, Vehicle...

Hello All, I do hope that someone can help me with this problem I am having... What I am trying to do is set a "Whole Number" verification on a calculator field..... The Calculation is on the "Number of Boxes" which is "Qty Ordered" / "Box Qty" So what I am looking to do is set a...

Hi Everyone, I have an Excel table. I am trying to perform a multi-column data validation. I am trying to use the COUNTIFS function like so: =COUNTIFS([Supplier],C2,[Supplier_Code],D2)<=1 The goal is to ensure that the data entered is not a duplicate. The combination of [Supplier] and...

I was wondering is it possible to lockdown a data validation list. i.e Make a dropdown list available for cells A2:A100. Then protect the sheet so that A2:A100 can use the dropdown available but that list to be locked so no one can either take the data validation off or change the list...

Hi, I am hoping you could assist me please. I have two (2) queries I need some help with. The first query is that I need selected cells to auto populate based on the Nomination Date (K14). I need Outcome Date (K15) to auto populate based on the date populated in K14 and plus 28 days; I also...