ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   multiline inputbox or msgbox message (https://www.excelbanter.com/excel-programming/368461-multiline-inputbox-msgbox-message.html)

jasminesy

multiline inputbox or msgbox message
 
Is there a piece of code that allows you to have a multiline message in an
inputbox or msgbox so that it appears as such:

Which do you want:
A for Apples
B for Bananna
c for Coconut

Thanks!

Die_Another_Day

multiline inputbox or msgbox message
 
Dim FruitBasket As String
FruitBasket = Application.InputBox("Which Do you Want:" & vbCrLf & "A
for Apple" & vbCrLf & "B for Banana" & vbCrLf & "C for Coconut", "I'm a
basket Case :)", , , , , , 2)

HTH

Die_Another_Day
jasminesy wrote:
Is there a piece of code that allows you to have a multiline message in an
inputbox or msgbox so that it appears as such:

Which do you want:
A for Apples
B for Bananna
c for Coconut

Thanks!



jasminesy

multiline inputbox or msgbox message
 
Thank You. This was actually what I had, but I forgot the second "&".

"Die_Another_Day" wrote:

Dim FruitBasket As String
FruitBasket = Application.InputBox("Which Do you Want:" & vbCrLf & "A
for Apple" & vbCrLf & "B for Banana" & vbCrLf & "C for Coconut", "I'm a
basket Case :)", , , , , , 2)

HTH

Die_Another_Day
jasminesy wrote:
Is there a piece of code that allows you to have a multiline message in an
inputbox or msgbox so that it appears as such:

Which do you want:
A for Apples
B for Bananna
c for Coconut

Thanks!





All times are GMT +1. The time now is 10:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com