Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
check input in cells
Hi expert,
I have an application that runs in a userform. The user can click a button and then returns to Excel where he can put in up to 1000 records of data (employees of a copany with their data, date of birth, salary etc.) How can i make sure that the user fills out all the nescessary cells ? If the user puts in a line i need to check if the cells in column B,C,E,F and G are filled in. if one of the cells is not filled in, the application gives an error message and is closed without saving. I would rather have the program givean error message stating that the data that is filled in the cells is not complete. Is there a way to check this ? Thanks, Pierre -- Message posted via http://www.officekb.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
check input in cells
Let's say you are dealing with row i. Try something link:
If IsEmpty(Cells(i, 2)) Or IsEmpty(Cells(i, 3)) Or IsEmpty(Cells(i, 5)) Or IsEmpty(Cells(i, 6)) Or IsEmpty(Cells(i, 7)) Then MsgBox ("Please complete input") End If End Sub Where the if is all in one line. -- Gary''s Student "Pierre via OfficeKB.com" wrote: Hi expert, I have an application that runs in a userform. The user can click a button and then returns to Excel where he can put in up to 1000 records of data (employees of a copany with their data, date of birth, salary etc.) How can i make sure that the user fills out all the nescessary cells ? If the user puts in a line i need to check if the cells in column B,C,E,F and G are filled in. if one of the cells is not filled in, the application gives an error message and is closed without saving. I would rather have the program givean error message stating that the data that is filled in the cells is not complete. Is there a way to check this ? Thanks, Pierre -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Input box data check | Excel Discussion (Misc queries) | |||
How to use Check Box input in a cell's fomula? | Excel Worksheet Functions | |||
Check input is a date | Excel Discussion (Misc queries) | |||
Check on the input in an inputbox | Excel Programming | |||
Check on the input in an inputbox | Excel Programming |