SetInputMessage Method

Sets the message that will be displayed when the user selects or hovers over the target Cell(s).

Syntax

Visual Basic
C#

'Declaration
 
Public Function SetInputMessage( _
   ByVal title As String, _
   ByVal text As String, _
   Optional ByVal show As Boolean _
) As DataValidation

'Usage
 
Dim instance As DataValidation
Dim title As String
Dim text As String
Dim show As Boolean
Dim value As DataValidation
 
value = instance.SetInputMessage(title, text, show)

public DataValidation SetInputMessage( 
   string title,
   string text,
   bool show
)

Parameters

title: The message's title.
text: The message's text.
show: When set to true, the target Cell(s) will display the message.

Example

DataValidation validation = DataValidation.Create( ValidationType.TextLength ).SetRange( 5, 10 ).SetInputMessage( "Please note:", "Value must be between 5 and 10!");

Requirements

Target Platforms: Windows 11, Windows 10, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

DataValidation Class
DataValidation Members