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.
Bookmarks