validation vba

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

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

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

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

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

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