Results 1 to 4 of 4

Message Box on Program Open - Way to have multiple lines of code vs one long line?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-29-2011
    Location
    Minnesota
    MS-Off Ver
    Office 365
    Posts
    163

    Message Box on Program Open - Way to have multiple lines of code vs one long line?

    I have a sheet with a message box pop up whenever the sheet is opened, and it works fine, but the code isn’t very user friendly because I have so much text in there that it is just one giant line that I have to arrow key through in order to find what needs to be changed. Is there a better way?

    The spreadsheet is something I make monthly to track open receivables and make it easier to find what our customers are trying to pay when the check isn’t detailed enough, and the pop up is used as a reminder of things to keep in mind whenever using the sheet. Things such as checks a customer has put a stop payment on so a reminder not to deposit it, or to let someone know when this customer paid this invoice, or whatever. Basically anything that I want the person doing the daily deposit to get a reminder on whenever they start the deposit.

    Is there a way to format this code in the VBA screen so that it’s more easily readable and user friendly instead of just one big giant line of code? I’m not talking about getting it in paragraph form or creating white space on the actual pop up itself – I have that – I’m talking strictly while writing the VBA code.

    Thanks for the help.
    Last edited by OpieWinston; 03-16-2018 at 11:26 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Break long line of code into multiple
    By phbryan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-20-2015, 11:30 AM
  2. [SOLVED] Splitting very long code over multiple lines in the editor....
    By swoop99 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-05-2014, 08:22 AM
  3. [SOLVED] How to convert selected multiple lines of a VBA code into comment line?
    By 1tane1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-29-2014, 11:04 AM
  4. [SOLVED] How to split this long string code in multiple line to avoid an error???
    By tuongtu3 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-24-2013, 10:08 PM
  5. Replies: 4
    Last Post: 08-21-2006, 01:20 PM
  6. Replies: 2
    Last Post: 01-30-2006, 11:20 AM
  7. [SOLVED] How can I program a message box to open when a user opens and exc.
    By Marcus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-16-2005, 12:14 AM

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