Hi Marcotte A,
if I am not mistaken, the limit is 1024 characters.
MP
"Marcotte A" a écrit dans le message de
...
Is there a limit on the size of the string you can pass to the prompt arg of
InputBox? For some reason it is not displaying the last line of my menu. MsgBox
works fine.

Dim Answer2 as Variant
Dim HelpMenu As String
HelpMenu = vbCr & "1. Introduction" & vbCr & "2. Summary Pages" _
& vbCr & "3. Store Pages" & vbCr & "4. Adding New Products/Stores" _
& vbCr & "5. Exit"
MsgBox HelpMenu 'this displays as expected
Answer2 = Application.InputBox(Title:="Menu", prompt:="Enter the number of a " _
& "menu item below." & HelpMenu)
'this only displays the first 4 lines of HelpMenu. Option 5 doesn't appear, but
I can still choose
'it and the code operates correctly

What am I missing here?