Can I simultaneously declare and assign a variable in VBA?

by

There is no shorthand in VBA unfortunately, The closest you will get is a purely visual thing using the : continuation character if you want it on one line for readability;

Dim clientToTest As String:  clientToTest = clientsToTest(i)
Dim clientString As Variant: clientString = Split(clientToTest)

Hint (summary of other answers/comments): Works with objects too (Excel 2010):

Dim ws  As Worksheet: Set ws = ActiveWorkbook.Worksheets("Sheet1")
Dim ws2 As New Worksheet: ws2.Name = "test"

More Related Contents:

  1. delete Autofilter Field resullt using the header Name
  2. Somehow it’s not copying [closed]
  3. Get list of sub-directories in VBA
  4. So, I have 6 “master” files to then divide into 40 separate files
  5. Application.Match gives type mismatch
  6. Count and Highlight keywords within phrases
  7. Protecting cells in Excel but allow these to be modified by VBA script
  8. Saving excel worksheet to CSV files with filename+worksheet name using VB [duplicate]
  9. How to type Unicode currency character in Visual Basic Editor
  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. Is “Value” actually the default property of the Range object?
  15. VBA – how to conditionally skip a for loop iteration
  16. VBA: How to delete filtered rows in Excel?
  17. How to use VBA SaveAs without closing calling workbook?
  18. Removing special characters VBA Excel
  19. Excel VBA Formula German/French/Italian/Russian/Dutch/Foreign Function
  20. selenium vba code to zoom out webpage to 60%
  21. Iterate over slicer via VBA and select a single item each time
  22. Return a range from A1 to the true last used cell
  23. When is a MailItem not a MailItem? [closed]
  24. Timing Delays in VBA
  25. How to add items to a combobox in a form in excel VBA?
  26. What are the benefits and risks of using the StrPtr function in VBA?
  27. How can I open this VBA workbook faster?
  28. Finding first blank row, then writing to it
  29. Copy an array reference in VBA
  30. What does the To and Step mean in VBA?

Leave a Comment