| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Error Alert Icon in Data Validation
See my original post. However, you could create your own validation code in the Worksheet_Change event. Then if the entry in the cell is not valid, display a userform with your custom image and message. Something possibly similar to this... Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Me.Range("B5").Value < 5 Then CustomUserForm.Show Unload CustomUserForm End Sub -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware wrote in message Sure. Can I add to or replace those three default icons? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation - Error Alert | New Users to Excel | |||
| Error Alert for Invalid Data doesn't work for data selected in col | Excel Worksheet Functions | |||
| popup alert in data validation | Excel Discussion (Misc queries) | |||
| data validation error alert does not work | Excel Discussion (Misc queries) | |||
| In Macros within the autofiltered icon to change data how possible | Excel Discussion (Misc queries) | |||
Threaded Mode
