How to continue the code on the next line in VBA

by

To have newline in code you use _

Example:

Dim a As Integer
a = 500 _
  + 80 _
  + 90

MsgBox a

More Related Contents:

  1. Loop through files in a folder using VBA?
  2. How to error handle 1004 Error with WorksheetFunction.VLookup?
  3. How can Excel VBA open file using default application
  4. How to compare two entire rows in a sheet
  5. Run same excel macro on multiple excel files
  6. how to detect whether VBA excel found something?
  7. VBA : save a file with UTF-8 without BOM
  8. Excel tab sheet names vs. Visual Basic sheet names
  9. Saving a Excel File into .txt format without quotes
  10. Excel VBA How to detect if something was pasted in a Worksheet
  11. Excel VBA “Method ‘Document’ of object ‘IWebBrowser2’ failed”
  12. Determine if cell contains data validation
  13. VBA – Range to jpg picture
  14. Fastest way to delete rows which cannot be grabbed with SpecialCells
  15. Combine multiple Excel workbooks into a single workbook
  16. Excel Macro, inserting internationally valid formula during run-time
  17. Sheet protection: UserInterFaceOnly gone
  18. VBScript – How to make program wait until process has finished?
  19. How to break long string to multiple lines
  20. How to copy a chart from Excel to PowerPoint?
  21. vba paste not working
  22. mac excel vba loop : from list & then export as pdf
  23. Can Advanced Filter criteria be in the VBA rather than a range?
  24. In Excel VBA, what is the way to check if the web page is fully loaded?
  25. Excel Useform: How to hide application but have icon in the taskbar
  26. Reading Web Pages using Excel VBA
  27. Excel VBA: auto click and open file from website
  28. How do I get a list of unique values from a range in Excel VBA?
  29. How to get selected value in multicolumn listbox
  30. Query my excel worksheet with VBA

Leave a Comment