validate

Hi I have a worksheet that has a cell for the user to provide a StartDate. Formulae use the contents of this cell L5 to populate 60 cells on the sheet with dates and days. This all works fine if the user enters a valid StartDate, but if the user wilfully or accidentally enters an invalid date...

Hi folks, I have the following coding that display a message should one of the mandatory fields be empty (validation). Now, my problem is that the placing of the variables in the MsgBox is hardocded, i.e. if all fields are filled except Postal code, Postal code will appear in the last line...

Hi, I have a list of external (web) hyperlinks in an Excel worksheet which I need to validate. I have looked for some code to check them, although have only found code to check internal (local network) links. Does anyone know of a good alternative solution? Cheers, Linesy

Hi! Newbie to the forum, I am currently developing an Excel template that lists and ranks candidates that have taken tests from an online platform our company uses. The main list contains all candidates by first and last names, their location, and tests taken. Many times a single candidate is...

Hi, I am stuck here.. I have a excel sheet with Values in Column B, C and T. When data is enetered into a new row on Culimn B or C then T must be completed with value. If T is not complete I want the user to be warned when they try to save or exit the Workbook and prevent the save. If...

I have an input range of 6 columns and 12 rows where the user can enter numbers which are to be calculated later. I am confused though how to determine whether the range has numerals only. Otherwise the output would throw an error. Is there a way to avoid this error?

I have a workbook open macro that I have been using for a while and tweaking every now and then but I am having truble with trying to check if data entered into an input box is in a range of cells on the sheet and if it is not then add it to the next blank spot in that range (the last 3 or 4 are...

Hi all, I need to create a bunch of 120 workbooks. In each of these I want certain cells to be restricted values. However, as these restricted values may change, I want them to be read from a master workbook where any change can be applied once, and be read by all the other workbooks. So for...

I have coded a macro that takes a data export from a companies proprietary system, manipulates some fields, and then saves as a new sheet to be parsed back into the system. The problem is that I just found out that the format of the data export, as in column order and extra columns, will change...

I have several columns of data, formerly in a LIST. (I can't use the list format because it screws up my formulas). I have an input range named .... 'input'... that I would like to format through Validation. I don't see an ability to format a range... or am i missing something? Thanks ron

I'm trying to build a simple order entry screen. I have an Item Table with a field representing the minimum qty that can be ordered for each item. In the order entry screen, I have a field to enter the qty the customer orders. I need a code to validate or automatically change the qty ordered...

I have a database on one sheet and a 2 count if formulae recording information on the next to be exact one formulae counts the number of monthly values and the other count yearly values. I want the sum of these formulaes to be equal or less than 25. and to show an error if the sum of these is...

Hello, I am trying to use a dropdown that is dependant on a first dropdown. I would like a set of choices to be available depending on what the first menu choice was. Is it possible to use a drop down with "IF"? for example: if the first dropdown has categories of groceries, like "dairy"...

Hi all, I can't believe I'm starting a thread for this, but I think my brain just burnt out (I can smell that electrical smell you get when something short-circuits).. Anyway, All I want to do is have a simple error message appear if a user trys to enter something other than a 2, 3, or 6...