Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Error Alert Icon in Data Validation
Is there a way I can add a custom icon to display when the error alert
pops up in a data validated box? Is there code I'd have to write, or does Excel reference a folder for those icons and I could add my image to that folder? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Error Alert Icon in Data Validation
I am not aware of any way using VBA to add a custom icon. There are three built in icons available when using the AlertStyle property of the Validation object. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware wrote in message Is there a way I can add a custom icon to display when the error alert pops up in a data validated box? Is there code I'd have to write, or does Excel reference a folder for those icons and I could add my image to that folder? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Error Alert Icon in Data Validation
On May 12, 9:16 am, "Jim Cone" wrote:
I am not aware of any way using VBA to add a custom icon. There are three built in icons available when using the AlertStyle property of the Validation object. -- Jim Cone San Francisco, USAhttp://www.realezsites.com/bus/primitivesoftware wrote in message Is there a way I can add a custom icon to display when the error alert pops up in a data validated box? Is there code I'd have to write, or does Excel reference a folder for those icons and I could add my image to that folder? Sure. Can I add to or replace those three default icons? |
#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? |
Reply |
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) |