Macros and templates IM CONFUSED

**Jerome19961996** · 11-16-2014, 08:38 PM

i need too know where too put this code? do put it in excel somewhere? and where too enter the line: Msg = Msg + vbCrLf, can someone tell me how too do this?

Sub Test2()

Dim Answer As String
Answer = MsgBox("Test 2", vbAbortRetryIgnore, "Test")
End Sub

Sub Test3()

Dim Msg, Style, Title, Response, MyString
Msg = "Do you want to continue ?" ' Define message.

Msg = Msg + "This is an extra long line. Will the box get"
Msg = Msg + " bigger or will it wordwrap ??"
Style = vbYesNo + vbCritical + vbDefaultButton2 ' Define buttons.
Title = "MsgBox Demonstration" ' Define title.

Response = MsgBox(Msg, Style, Title)

If Response = vbYes Then ' User chose Yes.
MyString = "Yes" ' Perform some action.
Else ' User chose No.
MyString = "No" ' Perform some action.
End If

Response = MsgBox("You pressed " & MyString, vbOKOnly, "Response")
End Sub

**pjwhitfield** · 11-16-2014, 08:47 PM

why start a 2nd thread? the answers in your 1st one (or at least enough to make you actually think a bit about doing your own homework)

http://www.excelforum.com/excel-prog...-confused.html

**alansidman** · 11-16-2014, 08:55 PM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

**alansidman** · 11-16-2014, 08:57 PM

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.