Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,327
Default 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/



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 253
Default 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/



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Using different lines in an input- or msgbox

That last tip was great thank

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
MsgBox text on several lines mohavv Excel Discussion (Misc queries) 1 November 21st 07 08:17 PM
input file with more than 250000 lines green1111 Excel Discussion (Misc queries) 2 April 26th 06 04:33 PM
How do I create a macro that will automatically input lines? cporter Setting up and Configuration of Excel 1 February 22nd 06 10:18 AM
Multiple lines in MsgBox NJF Excel Programming 3 January 13th 04 01:50 PM
MsgBox and User Input Terrin Excel Programming 2 September 9th 03 09:05 PM


All times are GMT +1. The time now is 03:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"