my code:
Code
' Location selection prompt
If vCriteria2 = "L" Then
vCriteria3 = Application.InputBox(Prompt:="Type in the code for the recipient you" _
& " wish to send the file to:" & Chr(13) & "ALB - ALBUQUERQUE" & Chr(13) & _
"PIT - Pittsburg" & Chr(13) & "COL - Colorado" & Chr(13) & "ELP - EL PASO" _
& Chr(13) & "FRE - FRESNO" & Chr(13) & "SOC - SOCAL" & Chr(13) & "PHO - PHOENIX" _
& Chr(13) & "SAC - SACRAMENTO" & Chr(13) & "SAL - SALINAS" & Chr(13) & _
"SLO - SAN LUIS OBISPO" & Chr(13) & "TUC - TUCSON" & Chr(13) & _
"Selection must be in ALL CAPS.", Title:="Location Email List", _
Type:=1 + 2)
End If
'Go no further if they Cancel.
If vCriteria3 = "False" Then Exit Sub
Display More
my problem:
message box pops up stating:
Type in the code for the recipient you wish to send the file to:
ALB - ALBUQUERQUE
PIT - Pittsburg
COL - Colorado
and cuts off here. How do i get the message box to extend out to show all my prompts?
side question too... can i add some form of code to allow it to take both upper and lower case? seems to be case specific and i hate to require the user to input ONLY caps for it to forward to my if statements.
oh... and there isnt such a thing as a pulldown box for selection in VBA code is there? I'm assuming a input box is my only way to allow such a selection. am i right?
as always, thanks so much for the help!