Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with InputBox and MsgBox | Excel Discussion (Misc queries) | |||
msgbox / inputbox etc | Excel Discussion (Misc queries) | |||
msgbox / inputbox etc | Excel Programming | |||
msgbox / inputbox etc | Excel Worksheet Functions | |||
msgbox / inputbox etc | Setting up and Configuration of Excel |