validations

  1. D

    VBA form question

    I have created a 23 column spreadsheet with data validation cells using drop down lists and a few columns that do the standard date formatting (4/18/19 displays as Thursday, April 18, 2019) Converting it to a table is not desirable and I would love to have a user form that "pulls" the...
  2. Dr. Demento

    Loop through xlCellTypeAllValidation

    I understand that I can loop thru .xlCellTypeAllValidation using a For Each loop; however, I'm looking to do things a bit more efficiently, specifically is there a way to group all similar validations into a single range using either .Areas or .xlCellTypeSameValidation...
  3. H

    Two Data Validations in a Single Cell

    Hi, I need to apply two data validations in a single cell. One is the name and other is a text 1) =validation_customers (This one is a named range) 2) ALL (This one is a simple Text) I would like to know how to apply these two in a single cell. Any help would be appreciated. Regards, Humayun
  4. L

    Data Validations and Indirect

    If I have in one drop down list(data validations) one thing how to connect with 2 or 3 more list. I know with Indirect functions but with that does not work(only works with one no more) Ty
  5. T

    A question on VALIDATIONS

    Hello everyone. I have a question regarding validations: How do I get my drop down to start at the top of the list when I engage the drop-down button? Currently when I click on it, the list pops up but it's at the end of the list and i have to scroll up each time? Any help is greatly...
  6. J

    Excel VBA Duplication Check on 250,000 rows

    Hello, I am trying to preform a duplicate row check on a data set spanning over 6 columns and approx. 250,000 rows of data. What I am trying to find is the more efficient way to highlight any duplicate rows. The code I have at the moment currently take around 45 minutes plus and I can’t help...
  7. S

    Excel validations

    Hi. i've a excel sheet where i need to perform validations. ex: i've a column by name Item Number. validations to be performed on column is: -> if user enters alphabets, it should display message Item Number should be numeric only. -> it should not be blank -> user should enter value only...

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