Skip to content

Latest commit

 

History

History
39 lines (24 loc) · 814 Bytes

Excel.Parameter.PromptString.md

File metadata and controls

39 lines (24 loc) · 814 Bytes
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Parameter.PromptString property (Excel)
vbaxl10.chm523075
vbaxl10.chm523075
Excel.Parameter.PromptString
e385bffd-fa89-a4c3-6442-d01d957f42d6
05/03/2019
medium

Parameter.PromptString property (Excel)

Returns the phrase that prompts the user for a parameter value in a parameter query. Read-only String.

Syntax

expression.PromptString

expression A variable that represents a Parameter object.

Example

This example modifies the parameter prompt string for query table one.

With Worksheets(1).QueryTables(1).Parameters(1) 
 .SetParam xlPrompt, "Please " & .PromptString 
End With

[!includeSupport and feedback]