How to break a long string into multiple lines

by

You cannot use the VB line-continuation character inside of a string.

SqlQueryString = "Insert into Employee values(" & txtEmployeeNo.Value & _
"','" & txtContractStartDate.Value &  _
"','" & txtSeatNo.Value & _
"','" & txtFloor.Value & "','" & txtLeaves.Value & "')"

More Related Contents:

  1. delete Autofilter Field resullt using the header Name
  2. VBA macro that search for file in multiple subfolders
  3. So, I have 6 “master” files to then divide into 40 separate files
  4. Getting ScriptControl to work with Excel 2010 x64
  5. Application.Match gives type mismatch
  6. Count and Highlight keywords within phrases
  7. Transpose a range in VBA
  8. Saving excel worksheet to CSV files with filename+worksheet name using VB [duplicate]
  9. Detect merged cells in VBA Excel with MergeArea
  10. Using VBA code, how to export Excel worksheets as image in Excel 2003?
  11. Parse HTML content in VBA
  12. How to add a DocumentProperty to CustomDocumentProperties in Excel?
  13. How do I name a spreadsheet automatically, by referencing two cells?
  14. Excel VBA Delete Rows
  15. VBA EXCEL To Prompt User Response to Select Folder and Return the Path as String Variable [duplicate]
  16. Should I turn .CutCopyMode back on before exiting my sub procedure?
  17. VBA: How to delete filtered rows in Excel?
  18. Determine whether user is adding or deleting rows
  19. How to use VBA SaveAs without closing calling workbook?
  20. Removing the password from a VBA project
  21. Removing special characters VBA Excel
  22. Excel VBA Formula German/French/Italian/Russian/Dutch/Foreign Function
  23. Loop through Excel Sheets
  24. Return a range from A1 to the true last used cell
  25. How to add items to a combobox in a form in excel VBA?
  26. Finding first blank row, then writing to it
  27. Run-time error ’91’ (Object variable or With block variable not set)
  28. Loop through cells and add to a range
  29. Copy last column with data on specified row to the next blank column
  30. Excel VBA- Iterate through columns in one workbook, pasting information in corresponding workbook

Leave a Comment