+ Reply to Thread
Results 1 to 3 of 3

I wanna create a pop message in excel. Each statement should reflect on next line

  1. #1
    Registered User
    Join Date
    02-28-2021
    Location
    India
    MS-Off Ver
    Microsoft office 365 proplus
    Posts
    1

    Post I wanna create a pop message in excel. Each statement should reflect on next line

    Private Sub AUS()
    VBA.Interaction.MsgBox "1)Check Baisc details with LOS like Borrower name,Subject property Address, Loan details, DTI & LTV rate.2)Any Mismatch we need to re run AUS.3)**Check Payoff and omitted account details.4)**Check Credit expiration date5)**Check Income documents requirment6)**Check Assets Document requirement7)**Check Apraisal Requirment.8)**Note down the Credit report ID and date and match with credit report.9)**Check the Total fund requirement."


    End Sub


    I have attached the screen shot how it is looking now.


    Microsoft office pop us message.JPG

    I want the output should reflect like this. Each statement should reflect on another line.

    AUS check point.

    1) Check Baisc details with LOS like Borrower name, Subject property Address, Loan details, DTI & LTV ratio. Any Mismatch we need to re run AUS.
    2) Check Payoff and omitted account details.
    3) Check Credit expiration date.
    4) Check Income documents requirment.
    5) Check Assets Document requirement.
    6) Check Appraisal Requirment.
    7) Note down the Credit report ID and dat and match with credit report.
    8) Check the Total fund requirement.

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,583

    Re: I wanna create a pop message in excel. Each statement should reflect on next line

    Code
    Please Login or Register  to view this content.
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

  3. #3
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,519

    Re: I wanna create a pop message in excel. Each statement should reflect on next line

    Or easier to follow
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Adjust IF statement to reflect new template requirements
    By lemonap618 in forum Excel General
    Replies: 7
    Last Post: 10-26-2020, 11:24 PM
  2. Altering line of code to reflect a variable.
    By sungen99 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-22-2017, 05:21 AM
  3. Horizontal and vertical scroll bar and a time line to reflect todays date
    By JamesJoshua in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-29-2016, 12:36 PM
  4. Replies: 3
    Last Post: 11-20-2009, 08:39 PM
  5. Replies: 1
    Last Post: 04-01-2009, 09:01 PM
  6. how to create a border in vb to reflect on the excel sheet
    By ckb in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-18-2007, 02:49 PM
  7. [SOLVED] Excel templates. Wanna make excel look like regular blue lined pap
    By havocdragon in forum Excel General
    Replies: 0
    Last Post: 03-03-2005, 06:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1