LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 15
Default InputBox function - prompt string limit

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 Varian
Dim HelpMenu As Strin
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 expecte
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 correctl

What am I missing here?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Text string sort limit Bob Laverty Excel Discussion (Misc queries) 1 May 27th 09 02:51 AM
Problem with VB string character limit. AJL Excel Worksheet Functions 0 November 3rd 06 07:40 PM
Validation through VBA using string has 255 char limit?????? Allan[_3_] Excel Programming 0 May 6th 04 11:51 PM
Fix InputBox - Returning Empty String spurtniq[_3_] Excel Programming 7 December 31st 03 06:23 PM
String length of Inputbox user input. Hersh Excel Programming 2 July 14th 03 08:47 PM


All times are GMT +1. The time now is 01:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"