Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data validation
Does anyone know how to have a text field (not a list) that will pop
an error message if the field is blank? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data validation
Data < Validation < Allow:Text Length < Data: greater than < Minimum: 0 <
uncheck Ignore Blank. You can use the Input Message tab and Error Alert Tab to inform the users of what they need to do and how to fix their error. It works. I've been using the validations for weeks to make sure my own people do what they're supposed to with my spreadsheets. QA Techie " wrote: Does anyone know how to have a text field (not a list) that will pop an error message if the field is blank? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data validation
You should really be more specific, it depends on what you are trying
to do. You could set up data validation on a cell, choose "Custom" from the Allow dropdown, put "=NOT(ISBLANK(A1))" in the formula box, and uncheck "Ignore Blank". Then if someone edits A1 and tries to backspace over what is already there (leaving the cell blank), they get an error message. Or if you were creating a userform, you could write some validation that checks the value of a text box. If it was blank, display error msg. For example, if you had a userform with a text box named TextBox1, this code would show an error message if you clicked on it and then clicked away without typing anything. Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean) If TextBox1.Value = "" Then Cancel = True MsgBox "You forgot to type something!", vbCritical End If End Sub HTH, JP On Mar 3, 4:39*pm, wrote: Does anyone know how to have a text field (not a list) that will pop an error message if the field is blank? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
Data Validation Update Validation Selection | Excel Worksheet Functions | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) |