Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Text string sort limit | Excel Discussion (Misc queries) | |||
Problem with VB string character limit. | Excel Worksheet Functions | |||
Validation through VBA using string has 255 char limit?????? | Excel Programming | |||
Fix InputBox - Returning Empty String | Excel Programming | |||
String length of Inputbox user input. | Excel Programming |