validation vba

  1. S

    Mandatory Column Validation in Excel

    hi, i am Trying to Create an Excel sheet that will have Few columns R1 will have the names of the columns suppose i have 5 columns say Name | DOB | ADDRESS |Contact | Member i want to make Name and DOB column mandatory. this xls may contain only 1 record or 100 or 1000 but this validation...
  2. A

    Validate a cell based on other - Mandate data entry

    HI , I am new to this forum and I am facing a problem with an excel sheet i am asked to make. Col0: Factor name Col1: Factor value (Initially blank) Col2: Comments (Initially blank) There are 10 rows. For each row, if the value in Col1 changes , the user must enter a value in Col2 before...
  3. A

    How to clear contents of a cell when another is changed (VBA)

    Hi, I am using drop down boxes (validation) and i want to clear the contents of 1 drop down cell when another drop down cell changes. Below is a code that works when i just click on the cell, but i want to modify it to be when a change occurs, not just with a click. Private Sub...
  4. E

    VBA validation rule

    I am trying to create a validation rule for a text box on my user input form. The input form is basically used to add food items to a spreadsheet. The user must enter an amount. I want the amount to be between 1 and 30000, so that if the user adds something outside of this (i.e text or -1), an...
  5. P

    Validating Data from another source

    Hi All, I'm using Excel 2003 had a look around the forum and couldn't find an answer to this so hoping that some brilliant person can point me in th right direction. <b>The problem</b> Each month I have around 200 different records that have been entered into a database by different people...
  6. H

    Auto update (extend) Name range

    I have defined a Name called 'Fruit' ranging from cell A1 to A3, say: A1 = Apple A2 = Orange A3 = Banana and i'll use this Name 'Fruit' as data validation (list) on sheet2 (source: =Fruit). If i were to add on A4 = Kiwi, A5 = Peach and so on.. Can the Name range 'Fuit' be extended...

Watch MrExcel Video

This Week's Hot Topics

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