ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Using different lines in an input- or msgbox (https://www.excelbanter.com/excel-programming/293141-using-different-lines-input-msgbox.html)

Syrus the Virus[_16_]

Using different lines in an input- or msgbox
 
I would like to use different lines (cq use enter) but I don't know how
I can make the macro press enter wiithin the string that defines th
text but then it accepts the inputbox.

HELP!!!

--
Message posted from http://www.ExcelForum.com


Harald Staff

Using different lines in an input- or msgbox
 
Hi

You should build a userform for that. Imputboxes are for simple small tasks.
http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
--
HTH. Best wishes Harald
Followup to newsgroup only please

"Syrus the Virus " skrev i
melding ...
I would like to use different lines (cq use enter) but I don't know how.
I can make the macro press enter wiithin the string that defines the
text but then it accepts the inputbox.

HELP!!!!


---
Message posted from http://www.ExcelForum.com/




Jean-Yves[_2_]

Using different lines in an input- or msgbox
 
Hi,

Sub test()
Dim strMsg As String
strMsg = "Your text" & vbCrLf & "In two lines"
MsgBox strMsg
End Sub

Regards,
Jean-Yves

"Syrus the Virus " wrote in
message ...
I would like to use different lines (cq use enter) but I don't know how.
I can make the macro press enter wiithin the string that defines the
text but then it accepts the inputbox.

HELP!!!!


---
Message posted from http://www.ExcelForum.com/




Syrus the Virus[_17_]

Using different lines in an input- or msgbox
 
That last tip was great thank

--
Message posted from http://www.ExcelForum.com



All times are GMT +1. The time now is 12:43 PM.

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